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

Рет қаралды 5,664

Күн бұрын

😎 BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! 👉 rebrand.ly/FreelancersAcademy...
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🔥GET 300 OF MY BEST TEMPLATES HERE► rebrand.ly/300Wkbks_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨‍💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN KZfaq MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this quick training, I share with you the foundational functions to quickly determine the last used row and column of any row, column, range or sheet in Excel.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/LastRowColumn_WkbkDl
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
1:13 - Why Is That Important?
2:57 - Last Used Row In Single Column
7:14 - Last Used Column In Single Row
8:53 - Last Used Row In A Range
10:03 - Last Used Column In A Range
10:59 - Last Used Cell In A Range
13:00 - Last Used Cell In A Worksheet
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #lastRow #LastColumn #excelVBA #VBATraining

Пікірлер: 21

@ExcelForFreelancers 2 ай бұрын

🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom

@rbrtktl 4 ай бұрын

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 4 ай бұрын

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.

@keitamoussa2229 4 ай бұрын

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 4 ай бұрын

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

@khrepairs8639 4 ай бұрын

Thank you and respect from Cambodia 🇰🇭

@ExcelForFreelancers 4 ай бұрын

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

@SyedMuzammilMahasanShahi 4 ай бұрын

Thanks Randy for this amazing video.

@ExcelForFreelancers 4 ай бұрын

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

@user-km7fg6sd8x 3 ай бұрын

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 3 ай бұрын

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.

@teoxengineer 4 ай бұрын

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 4 ай бұрын

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 4 ай бұрын

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 4 ай бұрын

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 4 ай бұрын

Everything is best

@ExcelForFreelancers 4 ай бұрын

Thank you so very much, I really appreciate that

@Thukai-Operater 4 ай бұрын

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

@kolavithonduraski5031 4 ай бұрын

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 4 ай бұрын

Hi and thanks so much. You can watch this series first video in which i explain that here: kzfaq.info/get/bejne/iLuZhaWGyse7ZJs.html I hope this helps and thanks so much.

@ExcelForFreelancers 4 ай бұрын

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