Mastering Excel Macros Series - Day 10 - How to find the last used row & column in Excel using VBA?

Welcome to Day 10 of the Mastering Excel Macros Series! In this video, we'll dive into 'How to find the last used row & column in Excel using VBA?'. This series teaching you how to automate repetitive tasks and enhance your productivity. Whether you're a beginner or looking to refine your skills, this series is designed to help you master the power of Excel macros and transform the way you work with spreadsheets.

VBA Script:
Sub Last_Row_And_Column()

Dim LR As Long
Dim LC As Long

LR = Cells(Rows.Count, 1).End(xlUp).Row
LC = Cells(1, Columns.Count).End(xlToLeft).Column

MsgBox LR
MsgBox LC

End Sub

Don't forget to follow me on Instagram for more tips and updates: mushtaq_m_a

If you enjoyed this video, make sure to hit the subscribe button and turn on notifications so you never miss an update! Thank you for watching!

📸 Follow me on Instagram for more tips and updates: mushtaq_m_a

👍 If you enjoyed this video, please subscribe to my channel and hit the notification bell to stay updated with the latest videos in the series!
#ExcelMacros #ExcelTips #ProductivityHacks #VBA #excel