find last used cell in row in a table

Jockster · #3 08-20-2014, 01:08 AM

Thanks for replying.
This doesn't do what I was hoping for however, the following does so have managed to get around the issue:

Quote:

LastColumn = Cells.Find(What:="", After:=ActiveCell.Offset(, 13), LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Select

Activecell.Offset (,13) - Active cell is the lookup value found in col "A" and the Offset part moves the start of the search area 13 columns away from the active cell; What:="" is searching for the first blank cell after col 13.

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