LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with function created in VBA Bob K Excel Worksheet Functions 3 December 15th 06 10:12 PM
Edit created worksheet function davidmac1954 Excel Worksheet Functions 1 October 10th 06 06:04 PM
Validation function that created from another drop down list Jamie Excel Discussion (Misc queries) 2 May 9th 06 12:56 AM
How do I total a column which was created using the MID function? CindyB Excel Worksheet Functions 6 February 10th 05 05:37 AM
How do I add help text to an excel function I have created Peter 99 Excel Worksheet Functions 2 January 14th 05 06:04 PM


All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"