In this video I show different methods for getting the last row and last column using VBA, including any pros and cons of each and in what situation you might use one over another.
Excel Version
Recorded using Excel Pro Plus 2021 but also works with Microsoft 365
You cannot run VBA/Macros directly in Excel online
Excel Tips Playlist
• EXCEL TIPS