hyperlink address

  1. K

    automaticall add hyperlink

    Hello, I am trying to make a list of files in excel. each cell needs to have a hyperlink, so when I click on the cell content it opens the file. With excel 2003 I used this code: With ActiveSheet i = 0 For Each rngCell In .Range("A1:A65530") i = i + 1 A$ = Cells(i, 2).Value + Cells(i...
  2. D

    Mass Hyperlink Edits?

    We have a workbook that has many worksheets. Each worksheet has many hyperlinks pointing to files on our network drive. The problem is the hyperlinks all point to the exact path: \\server1\excel\books\*.* Is there a way to edit all the hyperlinks in the workbook and doing a find/replace like...
  3. J

    Hyperlink.Item(1).Address #VALUE! Suppression?

    Although my first post to the MrExcel forum, I have been using you folks more and more in recent months whenever I've run into coding issues. :) In light of that fact, I am in need of assistence to determine how to intercept the error #VALUE! from showing up in my VBA hyperlink extraction...
  4. E

    Hyperlink to Cell on another sheet

    This one has been kicking my rear all morning. I have a macro that produces a list of certain cell references and the text content of that cell on a log sheet. What I want to do is have that cell reference in column A which looks like "Sheet2!B3" display just like that but also be a hyperlink...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top