Last cell in column
 

Try this for column A
MsgBox Range("A" & Rows.Count).End(xlUp).Value

This will select the cell

Sub LastCellInColumn()
Range("A" & Rows.Count).End(xlUp).Select
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Apfreight" wrote in message ...
Searching for a command that will show me the LAST value in a column. Not the
largest, but the last. Any help0 greatly appreciated.