Last row that contains data in a column

S

Spencer

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.
 
M

Mike

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
 
S

Spencer

how about something without a vba function.

Mike said:
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
Click to expand...
 
B

Bob Phillips

That's only last numeric value, not last value.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
R

Rowland

How bout the formula for finding the first row in a column that
contains data,the opposite of this solution.
 
Top