Hi, I am a newbie,please help.
I created a hyperlink to jump from cell a1 to n1 on sheet1, I copied
this link to sheet2, it will work the same on sheet2, however when I
modified the cell address on this hyperlink, it will only work on
sheet2 only. When I copied this hyperlink from sheet2 to sheet3, and
when I clicked on the link, it went from sheet3 back to sheet2, seems
to me when you modified a hyperlink, it will become worksheet specific.
Can someone please tell me how to correct this? Thanks in advance!
Tom


--
pohaku
------------------------------------------------------------------------
pohaku's Profile: http://www.excelforum.com/member.php...o&userid=29329
View this thread: http://www.excelforum.com/showthread...hreadid=490516