I think this training is the most important and fundamental topic for any app development in VBA. Thanks so much for summarizing all the methods. Finding the last column and row still gives me trouble to this day. I think it's because I always try to make it in 1 line of code, and I'm building completely crazy long lines (which magically works, but looks stupid and overcomplicated :)
Thank you so very much, I really appreciate that. for me, i have almost always used Sheet1.Range("A99999").end (xlup).row This has worked great for many years. I hope this helps and thanks so much.
Randy, those short videos are amazing, great additions to your full application tutorials. For those who are reading this comment, I am following Randy’s tutorials for years and I learned tons of information from this channel. Thanks Randy
Thank you so very much, I really appreciate that, even though you know VBA well, you still get value from these basic trainings. That is great to hear. Thank you for your Likes, Shares & Comments. It really helps.
Randy, I was looking at the auto sort video where a new name is alpha sorted automatically, and was wondering if you would consider adding code that would insert a row at the location where the new name ends up in the sort. I work with files that have more than 1 column and would benefit from this training. Thank you. I am enjoying and learning allot from your videos.
Hi and thanks so much. I saw this same comment on the other video. You are welcome to download any of these templates and customize them however you need. If you need help with a specific code, please post your issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Thank you so much for this tutorial. However, I was expecting to mantion about Usedrange in VBA. It is very useful coding to determine last date in sheet.
Hi and thanks so much. I will be dedicating and entire training to the UsedRange in the near future. Thank you for your Likes, Shares & Comments. It really helps.
Sir there are 3 buttons in a user form if i press button1 it save in a2 in sheet like this i press button 2 it save in b2 in sheet like this after 5 columns if I press button 3 it save a3 sir how can I do this?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@ExcelForFreelancers Sir, in the excel userform there are 10 buttons separately from 0 to 10. Around it, press btn1, that number1 gets added in column B2 of sheet1. In the same way press btn2, it gets added in column C2 of sheet1. In the same way it is till the last column H2. Then when I press any number, it becomes a new row, that means I start again from column B, that is row 3. Sir, how can we do that?
it is a programminglanguage which can be uused to control office applocations like Word, Excel and Powerpoint. You can as well use it with microsoft access. All this said... it is a way to automate stuff through different office applications. You can control them all through vba. This is extremly helpful to save time and build up small business applications, especially with a database like accesa. By the way... it ia a full programming lanuage. You can use dll-libraries, api's, web-scraping and so on. all possible. It is maybe not that easy and high-end as new languages, but it does the job and you learn a lot by programming with it.
Hi and thanks so much. You can watch this series first video in which i explain that here: th-cam.com/video/RUiRBUeaW4g/w-d-xo.html I hope this helps and thanks so much.
😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment
I think this training is the most important and fundamental topic for any app development in VBA. Thanks so much for summarizing all the methods. Finding the last column and row still gives me trouble to this day. I think it's because I always try to make it in 1 line of code, and I'm building completely crazy long lines (which magically works, but looks stupid and overcomplicated :)
Thank you so very much, I really appreciate that. for me, i have almost always used
Sheet1.Range("A99999").end (xlup).row
This has worked great for many years.
I hope this helps and thanks so much.
Randy, those short videos are amazing, great additions to your full application tutorials. For those who are reading this comment, I am following Randy’s tutorials for years and I learned tons of information from this channel. Thanks Randy
Thank you so very much, I really appreciate that, even though you know VBA well, you still get value from these basic trainings. That is great to hear.
Thank you for your Likes, Shares & Comments. It really helps.
You use last row in almost all of your training.
I hope to fully grasp it in this video.
Thanks for this free education!!!
Thank you so very much, I really appreciate that Keita, Yes that is true. Thanks again
Thank you and respect from Cambodia 🇰🇭
Thank you so very much, I really appreciate that and great to have you here
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
this is what i was looking for. Thanks Randy!
For sure, you are very welcome and I am happy to help and share
Thanks Randy for this amazing video.
For sure, you are very welcome and I am happy to help and share
Randy, I was looking at the auto sort video where a new name is alpha sorted automatically, and was wondering if you would consider adding code that would insert a row at the location where the new name ends up in the sort. I work with files that
have more than 1 column and would benefit from this training. Thank you. I am enjoying and learning allot from your
videos.
Hi and thanks so much. I saw this same comment on the other video. You are welcome to download any of these templates and customize them however you need. If you need help with a specific code, please post your issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to help you with this. Thanks so much.
Thank you so much for this tutorial.
However, I was expecting to mantion about Usedrange in VBA. It is very useful coding to determine last date in sheet.
Hi and thanks so much. I will be dedicating and entire training to the UsedRange in the near future. Thank you for your Likes, Shares & Comments. It really helps.
is there much difference in the code if the ranges are actually tables. find the first available cell in a table, last cell in a column
Hi and thanks so much, You can use this same code, even if the ranges are tables. I hope this helps and thanks so much.
Sir there are 3 buttons in a user form if i press button1 it save in a2 in sheet like this i press button 2 it save in b2 in sheet like this after 5 columns if I press button 3 it save a3 sir how can I do this?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@ExcelForFreelancers Sir, in the excel userform there are 10 buttons separately from 0 to 10. Around it, press btn1, that number1 gets added in column B2 of sheet1. In the same way press btn2, it gets added in column C2 of sheet1. In the same way it is till the last column H2. Then when I press any number, it becomes a new row, that means I start again from column B, that is row 3. Sir, how can we do that?
Everything is best
Thank you so very much, I really appreciate that
What is vba explain first sir and tell us how could we take benefit ater learning it
it is a programminglanguage which can be uused to control office applocations like Word, Excel and Powerpoint. You can as well use it with microsoft access.
All this said... it is a way to automate stuff through different office applications. You can control them all through vba.
This is extremly helpful to save time and build up small business applications, especially with a database like accesa.
By the way... it ia a full programming lanuage. You can use dll-libraries, api's, web-scraping and so on. all possible.
It is maybe not that easy and high-end as new languages, but it does the job and you learn a lot by programming with it.
Hi and thanks so much. You can watch this series first video in which i explain that here: th-cam.com/video/RUiRBUeaW4g/w-d-xo.html
I hope this helps and thanks so much.
Thanks for the great explanation @kolavithonduraski5031
Thank you for your Likes, Shares & Comments. It really helps.