I would like to take a moment to thank your for your efforts in explaining VBA, I've learned a lot watching VBA for beginners series, it is really interesting and I'm looking forward more videos to come
Already subscribed .. watched many videos, but learned much more from this one because the “nuts & bolts” come together to make sense of the reasons your methods work. Great job, sir - thank you! < learning this at 60+ years .. who’d a-thought>
HI Randy and thanks for Masterlass, If I have two workbooks, and I want to copy data from one to another, can I call worksheets via Code Name ? I dont want to use sheets (1) or worksheet.("name"), I want to refert to worksheets code name is it possible or not ? Thank you in advance
Yes for sure you can use the code name when calling the worksheets, even with multiple workbooks, with the same method, such as : Workbooks("WorkbookName.xlsm").Sheet1.Range("A1").Value I hope this helps and thanks so much.
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
I would like to take a moment to thank your for your efforts in explaining VBA, I've learned a lot watching VBA for beginners series, it is really interesting and I'm looking forward more videos to come
Thank you so very much, I really appreciate that
I learn VBA from you. Best teacher keep it up.
Thank you so very much, I really appreciate that
Already subscribed .. watched many videos, but learned much more from this one because the “nuts & bolts” come together to make sense of the reasons your methods work. Great job, sir - thank you!
< learning this at 60+ years .. who’d a-thought>
Thank you so very much, I really appreciate that and great to have you here
Thanks Randy for this amazing video.
For sure, you are very welcome Syed.
Thank you for your videos Randy. This channel has bee very helpful to me.
For sure, you are very welcome Raphael and I am very happy to help and share
The power of cell input values and how it can be manipulated in VBA to provide lightning fast results. Thank you Randy 😊
Thank you so very much, I really appreciate that Neren :)
Clear and concise, thanks again
Great, thanks so much. I am so glad you enjoyed it
Thank you very much Randy Sir, hugely helpful
For sure, you are very welcome and happy to help and share
Thank you again for your excellent explanation.Merry Christmas
For sure, you are very welcome and Merry Christmas to you as well
Many Thanks. Really appreciate it!
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
Amazing tutorial. Thanks a lot!
Thanks so very much Christopher. I am so glad you enjoyed it
Hope this serie also will continue for a long time.
Hi Keita, yes thanks I will keep it going. Thanks for the continued feedbak
Thank you
Thank you so very much, I really appreciate that
Thanks lot
For sure, you are very welcome
Very good
Thanks so much. I am really glad you enjoyed it
HI Randy and thanks for Masterlass,
If I have two workbooks, and I want to copy data from one to another, can I call worksheets via Code Name ?
I dont want to use sheets (1) or worksheet.("name"), I want to refert to worksheets code name is it possible or not ?
Thank you in advance
Yes for sure you can use the code name when calling the worksheets, even with multiple workbooks, with the same method, such as :
Workbooks("WorkbookName.xlsm").Sheet1.Range("A1").Value
I hope this helps and thanks so much.
Lovely
Thank you so very much, I really appreciate that
Great
Thank you so very much, I really appreciate that
Hi
Thank you for your Likes, Shares & Comments. It really helps.