Results 1 to 5 of 5

Renaming Hyperlinks

Threaded View

sjgidman1982 Renaming Hyperlinks 07-25-2016, 04:28 AM
zbor Re: Renaming Hyperlinks 07-25-2016, 04:28 AM
sjgidman1982 Re: Renaming Hyperlinks 07-25-2016, 04:35 AM
José Augusto Re: Renaming Hyperlinks 07-25-2016, 05:22 AM
sjgidman1982 Re: Renaming Hyperlinks 07-25-2016, 06:30 AM
  1. #1
    Registered User
    Join Date
    02-20-2009
    Location
    Stoke-on-Trent, England
    MS-Off Ver
    Excel 2013
    Posts
    12

    Renaming Hyperlinks

    hi i need some help renaming a lot of hyperlinks

    to start i have a list of 1000's of text links (ignore the space http:/ / it's the only way i could display it as text on this post)
    e.g
    http:/ /www.1.com
    http:/ /www.2.com
    http:/ /www.3.com

    then i used this macro to convert them to hyperlinks
    Sub HyperAdd()
    
        For Each xCell In Selection
            ActiveSheet.Hyperlinks.Add Anchor:=xCell, Address:=xCell.Formula
        Next xCell
    
    End Sub
    now i have
    http://www.1.com
    http://www.2.com
    http://www.3.com

    but i would like to change them all to
    Link
    Link
    Link

    is this possible by just changing my macro slightly?
    Last edited by sjgidman1982; 07-25-2016 at 04:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Range containing many hyperlinks is default blue font -fix to be black but keep hyperlinks
    By RedSummer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2015, 12:01 PM
  2. Mass renaming hyperlinks
    By benzo2014 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2015, 11:59 AM
  3. Renaming hyperlinks in excel
    By michibahn in forum Excel General
    Replies: 6
    Last Post: 04-09-2014, 03:49 PM
  4. Find Hyperlinks, Copy Hyperlinks to alternative sheet, print all hyperlinks
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 05:13 PM
  5. Renaming hyperlinks
    By CCobb in forum Excel General
    Replies: 2
    Last Post: 11-13-2012, 01:12 PM
  6. Replies: 7
    Last Post: 06-14-2012, 09:44 AM
  7. Hyperlinks and renaming tabs
    By woolyhedgehog in forum Excel General
    Replies: 0
    Last Post: 10-18-2005, 01:05 PM

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