Excel - lastcell

Asked By Danilo on 19-Jan-08 05:01 AM
with this code
ActiveCell.SpecialCells(xlCellTypeLastCell).Column i get always the
lastcolumn of the worksheet

I need to get the last column written of each single row in a sheet
How do i get it?

Tya




Mike replied on 19-Jan-08 05:11 AM
Try this

LastRowInColumn = Range("A65536").End(xlUp).Row

Change the A to the row you want

Mike
Danilo replied on 19-Jan-08 05:41 AM
no this give me the row, i need column for each row but i found this
Cells(x, Columns.Count).End(xlToLeft).Column