lastcell

[Danilo]

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 H]

Try this

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

Change the A to the row you want

Mike

 

[Danilo]

no this give me the row, i need column for each row but i found this
Cells(x, Columns.Count).End(xlToLeft).Column