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 :)
@ExcelForFreelancers3 ай бұрын
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.
@khrepairs863911 ай бұрын
Thank you and respect from Cambodia 🇰🇭
@ExcelForFreelancers11 ай бұрын
Thank you so very much, I really appreciate that and great to have you here
@rbrtktl10 ай бұрын
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
@ExcelForFreelancers10 ай бұрын
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.
@whitefox82913 ай бұрын
this is what i was looking for. Thanks Randy!
@ExcelForFreelancers3 ай бұрын
For sure, you are very welcome and I am happy to help and share
@keitamoussa222911 ай бұрын
You use last row in almost all of your training. I hope to fully grasp it in this video. Thanks for this free education!!!
@ExcelForFreelancers11 ай бұрын
Thank you so very much, I really appreciate that Keita, Yes that is true. Thanks again
@SyedMuzammilMahasanShahi11 ай бұрын
Thanks Randy for this amazing video.
@ExcelForFreelancers11 ай бұрын
For sure, you are very welcome and I am happy to help and share
@JosephMorana-u4f10 ай бұрын
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.
@ExcelForFreelancers10 ай бұрын
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.
@teoxengineer11 ай бұрын
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.
@ExcelForFreelancers11 ай бұрын
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.
@g1kuor11 ай бұрын
Everything is best
@ExcelForFreelancers11 ай бұрын
Thank you so very much, I really appreciate that
@peterjames804611 ай бұрын
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
@ExcelForFreelancers11 ай бұрын
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.
@TheTruthIeekerIfIslam29 күн бұрын
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?
@ExcelForFreelancers29 күн бұрын
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.
@TheTruthIeekerIfIslam20 күн бұрын
@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?
@Thukai-Operater11 ай бұрын
What is vba explain first sir and tell us how could we take benefit ater learning it
@kolavithonduraski503111 ай бұрын
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.
@ExcelForFreelancers11 ай бұрын
Hi and thanks so much. You can watch this series first video in which i explain that here: kzbin.info/www/bejne/iIbMg3WLmsaKask I hope this helps and thanks so much.
@ExcelForFreelancers11 ай бұрын
Thanks for the great explanation @kolavithonduraski5031 Thank you for your Likes, Shares & Comments. It really helps.