Using Excel Indirect Function in VBA

[@xavierrodestami40]

Thank you so much Dinesh Kumar! I was very confused for almost three hours with this struggle, and I was almost close to give up, but you explained quite properly, and it was easy to understand and follow along your tutorial.
Great work, and congratulations :D :D

[@darrenpuleston425]

You are providing the most useful VBA coding across UA-cam! I appreciate your efforts and will continue to follow. Please keep providing everyday useful code examples :)

[@ekaterinafeldman5394]

thank you so much, you are so clear with explanations, and you post the most useful stuff :)

[@krn14242]

Thanks Dinesh. Sounded like a thunderstorm in the background or was that just your microphone? Enjoyed your explanation and use of indirect.

[@Exceltrainingvideos]

Most probably my microphone at one point. Or did you hear the noise all the time?

[@PALESPANOLA]

hi thank you so much for your lectures , would u plz make a video on how we can update a table automatically in real time (modifying,adding or deleting new entry) to that table

[@andrizeefoshizee]

Is that a joke? How does Indirect(Tom) output the value in B4?

[@gerardvaneggermond9967]

Hello, I found this video interesting, but I still have a question, what if you want to add to a specific worksheet, for example, If cell E2 = 1 it refers to the first sheet in which it should search, how can i solve this?

[@Exceltrainingvideos]

Try using the path to the cell.

[@gerardvaneggermond9967]

@@Exceltrainingvideos Can you give me an example?

[@sadanandbhatt]

hi, i am getting error in .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=indirect(H17)" please help

[@Exceltrainingvideos]

What is the error?