How To Determine The Last Used Row & Column In Excel VBA

[@ExcelForFreelancers]

📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm

[@Robbie1987a]

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 :)

[@ExcelForFreelancers]

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.

[@rbrtktl]

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

[@ExcelForFreelancers]

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.

[@khrepairs8639]

Thank you and respect from Cambodia 🇰🇭

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and great to have you here

[@keitamoussa2229]

You use last row in almost all of your training. I hope to fully grasp it in this video. Thanks for this free education!!!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Keita, Yes that is true. Thanks again

[@whitefox8291]

this is what i was looking for. Thanks Randy!

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@JosephMorana-u4f]

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.

[@ExcelForFreelancers]

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.

[@SyedMuzammilMahasanShahi]

Thanks Randy for this amazing video.

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@teoxengineer]

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.

[@ExcelForFreelancers]

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.

[@peterjames8046]

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

[@ExcelForFreelancers]

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.

[@g1kuor]

Everything is best

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@Thukai-Operater]

What is vba explain first sir and tell us how could we take benefit ater learning it

[@kolavithonduraski5031]

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.

[@ExcelForFreelancers]

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.

[@ExcelForFreelancers]

Thanks for the great explanation @kolavithonduraski5031 Thank you for your Likes, Shares & Comments. It really helps.