Reading last cell

J

jackh7777777

Can someone please help, I want to make a summary sheet that reads the
contents of the last cell used in a column on another sheet. The cell i
want to read keeps moving down a column as data is inputed in the
workbook.
I know how to read the cell number but i need to read the contents.

This has been driving me crazy, Thank you
 
B

bgeier

use activecell.value

To find it in one step

use -variablename- = selection.end(xldown).value
 
G

Gary''s Student

For the value of the last cell in column A:

=LOOKUP(2,1/(A1:A65535>0),A1:A65535)

unless A65536 is also populated
 
Top