Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
If text is a hyperlink then return true 1
- Thread starter Davefeet
- Start date
-
1
- #2
SkipVought
Programmer
Dave,
pass a range, returns true/false
[tt]
Function IsHyperlink(rng As Range)
IsHyperlink = False
For Each h In rng.Hyperlinks
IsHyperlink = True
Next
End Function
[/tt]
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
pass a range, returns true/false
[tt]
Function IsHyperlink(rng As Range)
IsHyperlink = False
For Each h In rng.Hyperlinks
IsHyperlink = True
Next
End Function
[/tt]
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Status
Similar threads
- Locked
- Question
- Locked
- Question