how can I find last populated cell in a row (or column)
 

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
.

how can I find last populated cell in a row (or column)
 

Me being a dumba**:

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


-----Original Message-----
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
.

.