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

Try this

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

Change the A to the row you want

Mike

"Danilo" wrote:

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

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


"Mike H" ha scritto nel messaggio
...
Try this

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

Change the A to the row you want

Mike

"Danilo" wrote:

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