find last used cell in row in a table

excelledsoftware · #2 08-19-2014, 10:27 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Table with text that flows from cell to cell	hwrigley	Word Tables	7	02-18-2014 02:59 AM
Find out whether a cell has been typed or calculated	C J Squibb	Excel	1	10-01-2013 11:41 AM
cell of one table to display in a second table	HalinQuincy	Word Tables	4	04-03-2011 04:11 PM
VBA find or name a Table	smed	Word VBA	1	01-17-2011 02:18 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM