You need to qualify them with Application or WorksheetFunction.

--

HTH

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


"itarnak" wrote in
message ...

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