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.
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.