Hyperlink-link so that when a cell moves the link also moves?

03-15-06, 02:22 AM

peters

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

03-15-06, 04:32 AM

Doug Glancy

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" <peters> wrote in message
news:cc1e
[..]

03-15-06, 03:37 PM

Dave Peterson

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:
[..]

03-15-06, 05:17 PM

Doug Glancy

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" <petersod> wrote in message
news:cf35
[..]

03-15-06, 05:26 PM

Dave Peterson

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

Doug Glancy wrote:
[..]

Similar Threads
Safari: show URL when mouse moves over a link? I've been using Firefox for a while, but I thought I'd give the new Safari a try. Now, is there a Safari setting so that it shows the target URL when I move the mouse pointer...
down arrow key moves down, but it moves across to the right on continuse form I have a continuse form. When I hit down arrow key, it highlight moves across to the right instead of same field next record. Is it possible to move down when pressing down...
Keep link to picture file when destination file moves? I work for a large company and am getting tired of updating our company letterhead each time a branch changes a phone number which is located on the footer of all our...
exel hyperlink moves when adding new row or column
My Excel link to word moves the locationin in word When I copy an excel - cell and copy special and chose "by link" at a location in a Word sentance when i click OK it indents the location to the start of the next line. It...