how to write a macro that copies adjustable hyperlinks into a sprd

[Guest]

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

 

[Guest]

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,

 

[Guest]

thank you farhad, but i have too many cells to name each one invidually

 

[Guest]

Hi,

I knew that, but you said you are trying to write a macro so you can name
the cells in your macro and that was what i meant. well you know that the
names can be a fix string characters and a serial number that you can make it
in your macro very easy for example name1, name2, name3,.......

Thanks,