ROUNDDOWN function reference
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 |
ROUNDDOWN function reference
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 |
ROUNDDOWN function reference
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 |
ROUNDDOWN function reference
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 |
ROUNDDOWN function reference
Bob Phillips wrote:
It means something like MsgBox WorksheetFunction.Floor(var, 1) Oh, that's it. Thank you very much! |
All times are GMT +1. The time now is 04:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com