View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how do insert rows and maintain the hyperlink in Excel?

If it is in the same workbook, try using the Hyperlink Worksheet Function.
That alone may not be the solution, but should be the foundation.

--
Regards,
Tom Ogilvy


"muraz" wrote in message
...
I have created an Excel spreadsheet with hyperlinks to worksheets within

the
same spreadsheet. However, when I insert rows to here the hyperlink is
linked, the cell does not change to where the link should be connected to.
It stays the same. Any suggestions?