+ Reply to Thread
Results 1 to 3 of 3

Can Autofill be used to create Hyperlinks?

  1. #1
    Registered User
    Join Date
    06-13-2008
    Posts
    1

    Can Autofill be used to create Hyperlinks?

    When I create a hyperlink, to a cell in a distant column, on the same row, it works perfectly. However, if I try to then Autofill it down a range of rows the Hyperlinks fail to link to the correct cell address.

    The Hyperlink "text" displayed in each cell shows the correct destination cell address. However, the actual link address is identical to the very first cell used to create the Autofill.

    In other words, if the Hyperlink in cell A1 points to destination cell AK1
    and I autofill from that cell then cell A2...A40 all point to cell AK1. Even though the text displayed from cell A2...A40 has the correct incremented address, i.e. AK2......AK40
    Here's the first hyperlink text: UTM Pipeline!AK6
    Here's where the link takes me: UTM Pipeline!AK6

    Here's the second hyperlink text: UTM Pipeline!AK7
    Here's where the link takes me: UTM Pipeline!AK6

    Hope this makes sense.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Can Autofill be used to create Hyperlinks?

    Hello Bushy,

    Looks like you have answered you own question. No you can't use AutoFill for this. You would need a VBA macro.

  3. #3
    Forum Contributor FRIEL's Avatar
    Join Date
    03-07-2008
    Location
    Coventry
    MS-Off Ver
    2003 and 2007
    Posts
    266

    Re: Can Autofill be used to create Hyperlinks?

    i had a go at writing a macro for this but gave up.
    have you had any breakthoughs??
    I dont like to use code i dont understand
    it makes it hard to use in other situations
    so please try to be as clear and patent as possible with me

    Criticism is welcomed

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1