how to bulkly add hyperlinks to Excel

Posted on

How to bulky add hyperlinks to Excel

Here is an example of how to work effectively with Excel.
The situation is after merge two columns in Excel, the final column become a link whick like: http://www.microanalytix.co.nz/3ml-luer-lock-sterile-syringe.

However, these links are not hyperlink. Then the following step will let you know how to convert them into hyperlinks

  1. Alt+F11
  2. click view and code

  3. Copy the folllowing code into the new open window as below:

    Sub ActiveHyperlinks()

For Each C In [A2]

ActiveSheet.Hyperlinks.Add C, C.Value

Next

End Sub

    You could change A2 according to your requirements, for example, if you want to change A2 to A20, just modify it as [A2:A20].

  4. The last step is simple and easy, click run->Run Sub/UserForm.
  5. Then you would find the result in your original Excel.