Last active cell in a column

[Gary Brown]

Is there a formula I can use to locate the last active cell in a column. I did use the count function, however this isn't always reliable if there are blank cells within the column

[arthurbr]

Do you mean to search the last cell with a value in a column?
In this case there are multiple possibilities here

[DonkeyOte]

Assuming the values are numeric (implied by your COUNT comment) then:

=LOOKUP(9.99999999999999E+307,A1:A65536,ROW(1:65536))

where A is column in question - should return row position of last cell containing a number.
(assumes pre 07 in terms of possible row range)

EDIT: I would advise you read Bob's page as provided by Arthur as there are lots of good examples there.

[arthurbr]

Hi Donkey,
if you click on the link I provided, does it open the page ? ( it doesn't for me)

[DonkeyOte]

Yep -- works with all browsers I have available namely:

Google Chrome
FF
IE

[arthurbr]

Thx,
FF must be letting me down