RE: Reading last cell

Giganews Newsgroups
Subject: RE: Reading last cell
Posted by:  Gary''s Student
Date: Thu, 25 May 2006

For the value of the last cell in column A:

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

unless A65536 is also populated

--
Gary's Student

"jackh7777777" wrote:

>
> 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
>
> --
> jackh7777777
> ------------------------------------------------------------------------
> jackh7777777's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34814
> View this thread:http://www.excelforum.com/showthread.php?threadid=545703

Replies

None

In response to

Reading last cell posted by jackh7777777 on Thu, 25 May 2006