Try this

Application.Run "addin_name.xla!myextract", Var_Source_Fold,1,"B","\"

or set a reference to your addin project and call directly.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andibevan" wrote in message
...
Hi All,

I have a UDF that is contained in an add-in I have created myself
(MyAddin.xla)

I have been trying to utilise the UDF as follows:-

Var_TXT =
application.worksheetfunction.myextract(Var_Source _Fold,1,"B","\")

But keep getting this error "Object doesn't support this property or
method"

Any pointers?

Ta

Andi