Last row that contains data in a column
 

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.

Last row that contains data in a column
 

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.

Last row that contains data in a column
 

how about something without a vba function.

"Mike" wrote:

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.

Last row that contains data in a column
 

Try...

=LOOKUP(2,1/(A2:A100<""),A2:A100)

Hope this helps!

In article ,
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.

Last row that contains data in a column
 

See he http://support.microsoft.com/default.aspx/kb/152407

Dave
--
Brevity is the soul of wit.


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

Last row that contains data in a column
 

=LOOKUP(9.99999999999999E+307,C:C)


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

Last row that contains data in a column
 

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)



"Teethless mama" wrote in message
...
=LOOKUP(9.99999999999999E+307,C:C)


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

*First* row that contains data in a column
 

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

Teethless mama wrote:
=LOOKUP(9.99999999999999E+307,C:C)


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