The code below gives me the row number containing the last filled cell in column A.
How would the equivalent code look like to obtain the column number of the last filled cell in row 1?
LastRow = Range("A" & Rows.Count).End(xlUp).Row
Last edited by dschmitt; 03-11-2010 at 09:47 PM.
maybe something like this:
lastcol = Cells(1, Columns.Count).End(xlToLeft).Column
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks