Connexions

Sections
You are here: Home » Content » Hyperlink Search and Replace in Microsoft Excel

About: Hyperlink Search and Replace in Microsoft Excel

Module by: Trent Kelly

View content

Metadata

Name: Hyperlink Search and Replace in Microsoft Excel
ID: m17228
Language: English (en)
Summary: Many MS Excel users put hyperlinks in spreadsheet cells. If there is need to update a large number of hyperlink addresses in a spreadsheet due to reorganization or renaming of a server, it can be very time consuming to edit and update all the hyperlinks. This example code will locate and replace a designated group of characters in all the anchor text hyperlink addresses within a spreadsheet. If the URL has been typed directly into the cell, it can be found and replaced with the normal Excel search and replace function (Ctrl-h). If anchor text has been typed into the cell and then turned into a hyperlink, this code can search and replace the hidden URL's that normal search and replace will not find.
Subject: Business
Keywords: Excel, hyperlink, macro, Microsoft, URL, VBA, visual basic for applications
Document Type: -//CNX//DTD CNXML 0.5//EN
License: Creative Commons Attribution License (CC-BY 2.0)
Authors: Trent Kelly (advplc@yahoo.com)
Copyright Holders: Trent Kelly (advplc@yahoo.com)
Maintainers: Trent Kelly (advplc@yahoo.com)
Version: 1.2 (history)
Created: Jul 17, 2008 10:20 am GMT-5
Revised: Aug 4, 2008 1:29 pm GMT-5

Version History

Version: 1.2 Aug 4, 2008 1:29 pm GMT-5 by Trent Kelly
Changes: 
Edited description to clarify that the code applies to hyperlinks with anchor text and that hyperlink URLs entered into cells as text can be replaced with the normal Excel search and replace functions.
Version: 1.1 Jul 17, 2008 3:18 pm GMT-5 by Trent Kelly
Changes: 
First version - no changes

How to Reuse and Attribute This Content

If you derive a copy of this content using a Connexions account and publish your version, proper attribution of the original work will be automatically done for you.

If you reuse this work elsewhere, in order to comply with the attribution requirements of the license (CC-BY 2.0), you must include

  • the authors' names: Trent Kelly
  • the title of the work: Hyperlink Search and Replace in Microsoft Excel
  • the Connexions URL where the work can be found: http://cnx.org/content/m17228/1.2/

See the citation section below for examples you can copy.

How to Cite and Attribute This Content

The following citation styles comply with the attribution requirements for the license (CC-BY 2.0) of this work:

American Chemical Society (ACS) Style Guide:

Kelly, T. Hyperlink Search and Replace in Microsoft Excel, Connexions Web site. http://cnx.org/content/m17228/1.2/, Aug 4, 2008.

American Medical Assocation (AMA) Manual of Style:

Kelly T. Hyperlink Search and Replace in Microsoft Excel [Connexions Web site]. August 4, 2008. Available at: http://cnx.org/content/m17228/1.2/.

American Psychological Assocation (APA) Publication Manual:

Kelly, T. (2008, August 4). Hyperlink Search and Replace in Microsoft Excel. Retrieved from the Connexions Web site: http://cnx.org/content/m17228/1.2/

Chicago Manual of Style (Bibliography):

Kelly, Trent. "Hyperlink Search and Replace in Microsoft Excel." Connexions. August 4, 2008. http://cnx.org/content/m17228/1.2/.

Chicago Manual of Style (Note):

Trent Kelly, "Hyperlink Search and Replace in Microsoft Excel," Connexions, August 4, 2008, http://cnx.org/content/m17228/1.2/.

Chicago Manual of Style (Reference, in Author-Date style):

Kelly, T. 2008. Hyperlink Search and Replace in Microsoft Excel. Connexions, August 4, 2008. http://cnx.org/content/m17228/1.2/.

Modern Languages Association (MLA) Style Manual:

Kelly, Trent. Hyperlink Search and Replace in Microsoft Excel. Connexions. 4 Aug. 2008 <http://cnx.org/content/m17228/1.2/>.