Last row that contains data in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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...
 
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)
 
How bout the formula for finding the first row in a column that
contains data,the opposite of this solution.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Access #Error & Excel Pivot 0
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
VBA - retrieve data on last create named range from previous inserted named range 0
Find last column matching criteria 2
Return column header based on last value in row 3
Extract first value and last value from a table 1
Formula to choose from the last column of a given row 1

Back
Top