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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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,
 
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,
 
Back
Top