Excel Macro VBA to Find Last Row and Last Column

Thanks! Share it with your friends!

Close

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.

Comments

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

David

Write a comment

*

 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.