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

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

"Farhad" wrote:

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

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,
--
Farhad Hodjat


"BROCK8292" wrote:

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

"Farhad" wrote:

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