Hi,

I need to create a new function in VBA (this function is similar to the
vlookup one). This new function will have a range of cells as arguments.

public function myFunction (x as Range) as String

As a formula in one cell, I have
=myFunction('D:\anAnotherWb.xls]aSheet'!$A$1:$T$59)

I have the right result when x points on a range of cells in an already
opened workbook.
If x points to an existing workbook not already opened, I have a value error.

If you run the vlookup function, this problem do not appear. I'm pretty sure
the matter is the function declaration.


What would you do to solve my problem ?


Thx