I have aan excel sheet which has lot of hyperlinks. I have been trying to make a VB application which can check for the validity of all these hyperlinks. Please can someone help me with it.
Whats the difference between CONCAT and CONCATENATE?
Thanks a lot for the help. Howevr, can you please tweak it a bit.
1. The invalid link should not be deleted. Instead, the next cell in the row should be populated with some indicatyor like "Link OK", "Link Invalid".
2. The valid links hould not be launched to open the web pages. Instead just the mesage "Link OK" can be posted as specified above.