Try this:

=HYPERLINK("[My Workbook.xls]'My Sheet'!"&ADDRESS(ROW('My
Sheet'!A31),COLUMN('My Sheet'!A31)),"Named Link")

Now as the cell A31 on My Sheet moves around, the hyperlink will adjust
accordingly.

--
Best Regards,

Luke M
"George" wrote in message
...
(Excel 2002)

I recently discovered that Excel can hyperlink to another cell in the
same workbook, which looks to be very useful. In this re, ...

Using (row,col) designation, the link's 'reference' (using the word
loosly) appears to be absolute: If I set it to 'A31', and then
insert/delete row 29, the link will still be to 'A31' - as if I'd spec'd
$A$31, in most other contexts.

I know I can get around this by referencing a 'named' target cell. This
is OK, ... but, a litte more effort.

So, just to be sure I'm not missing something, is there a way to specify
a (row,col)-type hyperlink, so that it gets adjusted when insert/delete
changes move the target cell?

Thanks,
George