Functions in Excel macro
 

Hello,

I am trying to write an Excel macro. I want to use the following
functions that are available in Excel. Please let me know what are the
corresponding VB functions/syntax for the macro:
Excel Functions:
MOD(n,k)
Floor(n,k)
Ceiling(n,k)

Thanks

Srikanth


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Functions in Excel macro
 

Hi Srikanth

You can use the Floor and Ceiling worksheet functions in VBA thus:

Res = Application.WorksheetFunction.Floor(n, k)
Res = Application.WorksheetFunction.Ceiling(n, k)

VBA has its own Mod operator, the syntax being:

Res = n Mod k

---
Regards,
Norman



"Srikanth Ganesan" wrote in message
...

Hello,

I am trying to write an Excel macro. I want to use the following
functions that are available in Excel. Please let me know what are the
corresponding VB functions/syntax for the macro:
Excel Functions:
MOD(n,k)
Floor(n,k)
Ceiling(n,k)

Thanks

Srikanth


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Functions in Excel macro
 

Srikanth,

x = n Mod k
x = WorksheetFunction.Floor(n, k)
x = WorksheetFunction.Ceiling(n, k)

Regards,
Jim Cone
San Francisco, CA

Srikanth Ganesan" wrote in message ...
Hello,
I am trying to write an Excel macro. I want to use the following
functions that are available in Excel. Please let me know what are the
corresponding VB functions/syntax for the macro:
Excel Functions:
MOD(n,k)
Floor(n,k)
Ceiling(n,k)
Thanks
Srikanth