Hi,

You can name the cell in sheet2 and link the hyperlink in sheet1 to that
name so if any rows or column will add in sheet 2 it doesn't effect to your
hyperlink because the hyperlink knows just the name.

Thanks,
--
Farhad Hodjat


"BROCK8292" wrote:

im trying to write a macro that will add hyperlinks in column a of sheet 1
for 1000 rows linking them to the corresponding cells in sheet 2(ie.
hyperlink in cell a1 of sheet 1 will bring you to cell a1 of sheet 2).
however i need the hyperlinks in sheet 1 to be able to adjust when i add rows
into sheet 2 after the hyperlinks are set.
any help would be greatly appreciated
thank you
brock