ROUNDDOWN function reference

D

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
 
B

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)
 
D

dtdd

Bob said:
There are not VBA functions. Did you qualify them with WorksheetFunction?
Click to expand...
I am not sure what "qualify them with WorksheetFunction" means...

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

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)
 
Top