standard functions not renognized

[itarnak]

With Excel 2000/VBA 6.0 :

Functions like TRUNC, FIND, etc are not recognized by excel.

Excel says: undefined sub or function..


What does that mean??

iTarnak

[Bob Phillips]

You need to qualify them with Application or WorksheetFunction.

--

HTH

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


"itarnak" <[email protected]> wrote in
message news:[email protected]...
>
> With Excel 2000/VBA 6.0 :
>
> Functions like TRUNC, FIND, etc are not recognized by excel.
>
> Excel says: undefined sub or function..
>
>
> What does that mean??
>
> iTarnak
>
>
> --
> itarnak
> ------------------------------------------------------------------------
> itarnak's Profile:
http://www.excelforum.com/member.php...o&userid=27865
> View this thread: http://www.excelforum.com/showthread...hreadid=478717
>