Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Michael,
How can I use a full path name as a range argument in a user defined function You could try putting the link in another cell and reference that cell in the call to the udf. Another option is to define a name that refers to the other workbook and use that name in the call to the udf. e.g. : Insert, name, define Name: ExternalLink Refersto:='c:\data\[test.xls]Sheet1'!$A$1:$c$4 Then in another cell: =YourUDF(ExternalLink,Otherargs) Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
user defined function | Excel Worksheet Functions | |||
vlookup, add parameter, on error return user defined value | Excel Worksheet Functions | |||
Opening workbook in user-defined folder | Excel Worksheet Functions | |||
user defined function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |