Thanks All - much appreciated

"Tom Ogilvy" wrote in message
...
Only a subset of built in Excel functions are methods of the
WorksheetFunction object.

Var_TXT = application.Run( "AddinName.XLA!myextract",
Var_Source_Fold,1,"B","\")

--
Regards,
Tom Ogilvy


"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