Goto Last Cell function

[Julius]

Hello Group,

I have an application where I would like to create a
function that goes to the last cell in a spreadsheet. I
can get this to work if I manually use the
<Goto...special...last cell> function, but when I put this
command into a macro and increase the length of the
spreadsheet, the macro will only go as far as the last
cell when the macro was saved.

Any suggestions?

Thanks,
Julius

 

[Peo Sjoblom]

Here's a slick formula from Harlan that will return what's in the last
cell in a column,

=LOOKUP(2,1/(1-ISBLANK(A1:A10000)),A1:A10000)

if you need the whole column use A65535 instead of A10000

If you mean physically select the last cell you can't do that with a
function,
you would need VBA for that

Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)