<div>
Try the macro shown on this page:<br />
<br />
<a href="http://www.excelforum.com/excel-worksheet-functions/621943-hyperlink-macro-to-internet.html" rel="ugc">http://www.excelforum.com/excel-worksheet-functions/621943-hyperlink-macro-to-internet.html</a>
</div>


Try the macro shown on this page:

http://www.excelforum.com/excel-worksheet-functions/621943-hyperlink-macro-to-internet.html [http://www.excelforum.com/excel-worksheet-functions/621943-hyperlink-macro-to-internet.html]

<div>
Yes, the macro does work, but I cannot igure out how to modfiy it for my needs. &nbsp;Instead of it popping up a MSG window when it find a bad hyperlink, I want it to CLEAR the cell with the bad hyperlink. &nbsp;How would I change the macro to accomplish this?
</div>


Yes, the macro does work, but I cannot igure out how to modfiy it for my needs.  Instead of it popping up a MSG window when it find a bad hyperlink, I want it to CLEAR the cell with the bad hyperlink.  How would I change the macro to accomplish this?

<div>
Ok maybe we need to make a loop for every cell then call the function that will perform Cell.ClearnContent()<br />
<br />
I will try also and get back to you
</div>


Ok maybe we need to make a loop for every cell then call the function that will perform Cell.ClearnContent()

I will try also and get back to you

<div>
I am working on a different solution but will still try to integrate yours for future use. &nbsp;Points awarded.
</div>


I am working on a different solution but will still try to integrate yours for future use.  Points awarded.

<div>
<div class="content wysiwyg-content">
Using excel 2007, is there a formula or way to test a GENERATED hyperlink in a cell in EXCEL? &nbsp;One of my spreadsheets creates a list of hyperlinks and I was wondering if there was a way or forumla to test the hyperlink in each box to see if the file located at the http address pointed to from the cell really exists on the server or not.
</div>
</div>


Using excel 2007, is there a formula or way to test a GENERATED hyperlink in a cell in EXCEL?  One of my spreadsheets creates a list of hyperlinks and I was wondering if there was a way or forumla to test the hyperlink in each box to see if the file located at the http address pointed to from the cell really exists on the server or not.

hyperlink test in excel

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.