Checking validation on a column of URLs

cidlockie

New Member
Joined
Apr 8, 2005
Messages
4
Hello - very quick question this and I suspect it's possible, but I can't find out how.

I have a column of hyperlinks, one per cell, around 1,000 of them in all. I need to check whether each and every link is valid - basically, if it opens a web page, bingo, if it's broken, curses.

As an added annoyance, some of the links are to PDfs.

Is there any way to do this in excel without having to click each one to find out if it works?

Thanks in advance,
Chris.
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,118,448
Messages
5,572,174
Members
412,447
Latest member
immy
Top