VBA to check hyperlink exist or no

[Undo]

Hi

I want vba to check my table hyperlinks in first column
if files there, don't do any thing, if not here, paste NO in same row, column AVAILABLE
then it will be red because I make a conditional formatting
kindly use table references as range, don't use sheet range

Thanks

[WideBoyDixon]

Try this:

Please Login or Register  to view this content.

WBD

[Undo]

Thank you, what if path is http (/), not internal path (\)

[WideBoyDixon]

Then you can't check if it exists in this way. You'd have to try and establish a connection and check for a 404 error.

WBD