Hello,
I am in need of a macro that will check to see if a hyperlink is valid. I am using the hyperlink function in Excel, not the wizard.
I have a large worksheet, and I would like the macro to test each hyperlink for validity without opening each file.
I found a thread that set me on the right direction here.
Here is the code that I have been using.
This code works great, but only if I hyperlink the files using the wizard. I have been using the formula for hyperlink because I need to include a cellular reference for the name of the file.Please Login or Register to view this content.
Here is a sample of the formula that I have been using to produce the hyperlink.
Formula:Please Login or Register to view this content.
I have Excel 2016.
This seems like a fairly simple change, but I don't know what to do. Please help!
Thanks,
Joe
Bookmarks