ashish koul
Member
If you want to extract hyperlink address from a cell. Try this udf-
[pre]
[/pre]
[pre]
Code:
Function hyperlink_extcell(cell As Range)
If cell.Hyperlinks.Count > 0 Then
hyperlink_extcell = cell.Hyperlinks(1).Address
Else
hyperlink_extcell = "Hyperlink Not Found"
End If
End Function