View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bhilton84 bhilton84 is offline
external usenet poster
 
Posts: 3
Default I created a UDF but I can't run the function ...

I created a UDF but I can't run the function. Do I have to save the function
under the worksheet or workbook or something else? Also, do I need the
Analysis toolpak - VBA to make the function work. The function is as follows:

Function GetHyperlinkAddress(Rng As Range) As String
With Rng
If .Hyperlinks.Count 0 Then
GetHyperlinkAddress = .Hyperlinks(1).Address
End If
End With
End Function