Help with hyperlink

  • Thread starter Thread starter AlisonB
  • Start date Start date
A

AlisonB

Hi,

Someone else posted a topic a while ago that is similiar to something I
would like to do - but not quite! (Topic is now close by a moderator
as it was in 2004).

The original post was -

" Is it there a formula, that if you click on a Cell, you automatically
go to another Cell in that worksheet? (without using a macro?)

And the reply suggested using -

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

I have tried this and can see how this works, but the cell the formula
is in shows an underlined zero. How can I change the formula to give
me an asterix instead of an underlined zero?

Kind regards,

Alison
 
Back
Top