I have created a function that needs a range as an
argument. It is similar to the VLOOKUP function, except
it can use more than one column as it's search key.
Anyway, when I call the function in a cell, and I use an
external reference to another workbook, it gives me
#VALUE!. If I have the external workbook open it works
fine, but as soon as I close it, and the argument in the
formula changes to the full path name of the file, it
fails. How can I use a full path name as a range argument
in a user defined function?

Thanx!