title: Checking for broken hyperlinks in Excel
body: <p>I have a large list of hyperlinks (plus a few cells of nonsense) that I need to check. I need to know which links are still active and which no longer exist or return a 404 (or other) Error. I have been using the advice in this entry: <a href="https://stackoverflow.com/questions/1118221/sort-dead-hyperlinks-in-excel-with-vba">Sort dead hyperlinks in Excel with VBA?</a> and it worked great in a small selection of links, some of which I deliberately broke myself. However, now that I try to use the same macro on my actual list of hyperlinks it won't work at all! I've manually checked a few and have found links with 404 errors. Again, when I deliberately mistype one of the addresses it will pick that up but it won't pick up any in the list that were broken already.</p>
  
  <p>I'm totally new to macros and am really stumbling about in the dark here. Any help/advice would be very much appreciated!</p>