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

peters,

I've never used hyperlinks to other cells, but I notice that you can point
it to a named range. Then the link still points to the same cell if you add
rows above it, etc. But the link shows the range name, not the cell
address, which could be a good thing or a bad thing, I guess.

hth,

Doug


"peters" wrote in message
...
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

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

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

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