There are not VBA functions. Did you qualify them with WorksheetFunction?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"dtdd" <dd@eer wrote in message
...
I am trying to use ROUNDDOWN or/and FLOOR functions in my excel macro,
but compiler doesn't find them.
Currently my references include:
Visual Basic for Applications
Microsoft Excel 9.0 Object Library
OLE Automation
MS Forms 2.0
MS DAO 3.51

Any help is appreciated.

Thanks