This would set x to the value of the bottom used cell in Col A

Sub LastCellInColumn()
Range("A65536").End(xlUp).Select
x = ActiveCell.Value
End Sub

"Spencer" wrote:

my excel skills must be getting rusty as i do not use it as heavily anymore.
but can anyone help me with a function. i need to return the value of the
last cell in a column that contains data. thanks.