LAST free cell in row

Topic

New Reply

How to have the number of last free cell in range A2:IV2…
In this my case 4 (D2 is the free last cell)

Reply | Quote

Replies

You can use

LastCol = Range(“IV2”).End(xlToLeft).Column + 1

or if you want to be certain it’ll work in Excel 2007 and later too:

LastCol = Cells(2, Columns.Count).End(xlToLeft).Column + 1

Reply | Quote

You can use

LastCol = Range(“IV2”).End(xlToLeft).Column + 1

or if you want to be certain it’ll work in Excel 2007 and later too:

LastCol = Cells(2, Columns.Count).End(xlToLeft).Column + 1

good!

Reply | Quote

How to have the number of last free cell in range A2:IV2…
In this my case 4 (D2 is the free last cell)

Doing it by means of a formula:

Control+shift+enter, not just enter…

=MATCH(2,1/(1-ISBLANK(A2:IV2)))+1

If A2:IV2 is empty (unused), the result will be #N/A.

Reply | Quote