Thread: [Solved] find last used cell in row in a table
View Single Post
 
Old 08-19-2014, 10:27 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
  
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default
I found this trick a little bit ago and it has been amazing for finding the last row

Code:
FinalRow = Range("A50000").End(XlUp).Row + 2   'experiment what to add
'to make the last row you actually want get selected.
I tried this with your workbook and it appeared to work just fine but when you say the last row used you will need to change the number added on the end of the statement to get it to grab what you want. Also if your worksheet is longer than 50,000 rows just increase that amount in the range.

Let me know if that works

Thanks
Reply With Quote