Hi all
I would like to be able to automatically print the hyperlink target in the following code without opening it. Is this possible?

If SheetExists("SLA") Then
Range("B25").Select
ActiveCell.FormulaR1C1 = "Yes"
h = h + 1
With Worksheets(1)
.Hyperlinks.Add .Range("B25"), "http://abcgis1.ashford.gov.uk/website/locplan/EN27.html"
.Hyperlinks(h).TextToDisplay = "Yes"
End With
Else
Range("B25").Select
ActiveCell.FormulaR1C1 = "No"
End If

Thanks in advance for any suggestions.
Regards
Liz