Excel Macro VBA to Find Last Row and Last Column

Thanks! Share it with your friends!


This video shows quite an advanced method for finding the last cell with data in it either vertically or horizontally.

We have never used this method in all the years we have been writing code but it is a pretty cool trick and well worth watching.

It covers the .End(xlToLeft) function and the .End(xlUp) options for ranges.

If you have learnt something new in this video (which we hope you have) please like or share it using the button above or leave us a comment below.


dhanraj says:

How to create macro and i need with example?

Roger says:

Hi – Check out the VBA pages on this site – there are a few videos that will help you get started there.

David says:

Have really enjoyed the lessons and have certainly learned a lot


Write a comment


Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.