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)

"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

Bob Phillips wrote:

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

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" <dd@eer wrote in message
...
Bob Phillips wrote:

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 wrote:

It means something like

MsgBox WorksheetFunction.Floor(var, 1)

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