ROUNDDOWN function reference

  • Thread starter Thread starter dtdd
  • Start date Start date
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
 
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)
 
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
 
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)
 
Back
Top