Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi gang,
    In WorksheetA I inserted a hyperlink to cell C3 in WorksheetB.
    If I add a row in WorksheetB the hyperlink bring me to cell C3 but it should bring me to cell C4.
    How can I have the hyperlink adjust if I add rows of column to WorksheetB?
    tks
    jc
    Johanne Champagne
    Montreal (Quebec) CANADA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Defined names to the rescue again!

    Use Insert | Name | Define... to give cell C3 on WorksheetB a name, e.g. MyCell. You can also select C3 on WorksheetB and type the name in the address box on the left hand side of the formula bar, then press Enter.

    When you create a new hyperlink and select Place in this document, you'll see MyCell under Defined names in the treeview of possible targets. Select MyCell and proceed as usual.

    If you insert or delete cells, rows or columns, the defined name will adjust its target automatically.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Defined names! So powerful.
    Tks Hans.
    Johanne Champagne
    Montreal (Quebec) CANADA

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Without a range name you could use this formula:

    =HYPERLINK("#"&CELL("address",Sheet2!A6),"TextToDi splay")
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •