Compile Error, Sub or Function not defined

[OOP]

Hi,

I'm using RoundDown function in Visual Basic with Excel worksheets but when i run the program, it prompts me a Compile Error. Is it because RoundDown is not supported in VB. Have changed to Floor but still the same problem..
Please help.Thanks.

 

[xlbo]

use F2 (object model shortcut) and search on the data members for the APPLICATION.WORKSHEETFUNCTION class - this will tell you which formulae are available to VBA

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[OOP]

Thanks. Geoff.
Actually i did not include the WorksheetFunction before RoundDown
Thanks again.

 

[xlbo]

That may be your problem then ;-)

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question