ROUNDDOWN function reference

[dtdd]

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

 

[Bob Phillips]

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]

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

I am not sure what "qualify them with WorksheetFunction" means...

I did Debug->Compile VBA project, and it returned error

 

[Bob Phillips]

It means something like

MsgBox WorksheetFunction.Floor(var, 1)

--

HTH

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

 

[dtdd]

It means something like

MsgBox WorksheetFunction.Floor(var, 1)

Oh, that's it.
Thank you very much!