[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 462
  • Last Modified:

hyperlink test in excel

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.
0
THE_HORSEPOWERSHOP
Asked:
THE_HORSEPOWERSHOP
  • 3
  • 2
1 Solution
 
mgonulluCommented:
0
 
THE_HORSEPOWERSHOPAuthor Commented:
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?
0
 
mgonulluCommented:
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
0
 
mgonulluCommented:
Hey I think I found the solution:
The below is an example to do the loop:

Sub LoopCells()
For Each c In Worksheets("Sheet1").Range("a2:f2").Cells
c.Value = "KLP"
Next c
End Sub


The use the function described in this website:
http://www.utteraccess.com/forums/printthread.php?Cat=&Board=84&main=1037294&type=thread

That should work fine
0
 
THE_HORSEPOWERSHOPAuthor Commented:
I am working on a different solution but will still try to integrate yours for future use.  Points awarded.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now