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

G

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)
 
G

gigglefritz

Me being a dumba**:

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