Damn interface:

Row:
Dim lastCell As Range
Set lastCell = Range("IV" & Columns.Count).End
(xlToLeft)

Column:

Dim lastCell As Range
Set lastCell = Range("A" & Rows.Count).End(xlUp)

-----Original Message-----
Hi,
how can I find last populated (not null) cell in a row
(or column)

thanx

alekm
.