+ Reply to Thread
Results 1 to 2 of 2

Is it possible to use 'Replace All' function in hyperlinks

  1. #1
    Registered User
    Join Date
    08-04-2006
    Posts
    1

    Question Is it possible to use 'Replace All' function in hyperlinks

    In Excel is it possible to use 'Replace All' function in hyperlinks. Normally, if you do a replace all in excel, it replaces the contents of the cells but not the hyper links. I want to change one particular word in around 100 hyperlinks in one particular master file. Pls use your sources and advise.

    Somehow i need to modify the hyperlink text in all the hundred of them.
    If there is any VB code that i can run in Visual basic Editor for doing this than please provide it.

  2. #2
    Dave Peterson
    Guest

    Re: Is it possible to use 'Replace All' function in hyperlinks

    If you used the worksheet function =hyperlink(), then edit|replace will work
    nicely!

    But I bet you used insert|hyperlink.

    Take a look at David McRitchie's site:
    http://www.mvps.org/dmcritchie/excel/buildtoc.htm
    look for:
    Fix Hyperlinks (#FixHyperlinks)

    If you're new to macros, you may want to read David McRitchie's intro at:
    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    prabhat_79_in wrote:
    >
    > In Excel is it possible to use 'Replace All' function in hyperlinks.
    > Normally, if you do a replace all in excel, it replaces the contents of
    > the cells but not the hyper links. I want to change one particular word
    > in around 100 hyperlinks in one particular master file. Pls use your
    > sources and advise.
    >
    > Somehow i need to modify the hyperlink text in all the hundred of
    > them.
    > If there is any VB code that i can run in Visual basic Editor for doing
    > this than please provide it.
    >
    > --
    > prabhat_79_in
    > ------------------------------------------------------------------------
    > prabhat_79_in's Profile: http://www.excelforum.com/member.php...o&userid=37112
    > View this thread: http://www.excelforum.com/showthread...hreadid=568450


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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