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

[gigglefritz]

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)

 

[gigglefritz]

Me being a dumba**:

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