read value of last cell in column

[S.E.]

How do I read the value of the last cell (the bottom one) in a given column?

Scott

 

[Tom Ogilvy]

msgbox Cells(rows.count,"A").End(xlup).Value