I have to find David McRitchie's post each time I want to use it <bg.

Doug Glancy wrote:

And it still works if you change the sheet or workbook name. It's one of
those formulas I'll never remember on my own - I never find the Cell
function easy to use - but it's cool.

I played around with it a bit more. If you want the hyperlink to show the
cell address - rather than it's contents - this seems to work. Most of the
additional bulk of the formula is due to stripping out the workbook name,
which would be redundant.

=HYPERLINK("#"&CELL("address",Sheet1!A1),MID(CELL( "address",Sheet1!A1),FIND("]",CELL("address",Sheet1!A1))+1,256))

Doug

"Dave Peterson" wrote in message
...
Another way is to use the =hyperlink() worksheet formula. Since it's a
normal
formula, it reacts to inserting/deleting of rows/columns.

David McRitchie posted this and it might help you:

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



peters wrote:

with a hyperlink to a cell, when that cell moves (for whatever reason) is
it
possible to make the hyperlink move with it.

Many thanks

--

Dave Peterson

--

Dave Peterson