Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MOD function
I'm having trouble finding the MOD function. It doesn't
seem to be accessible through WorksheetFunction. Anybody know how I can access it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MOD function
Strat,
Try Debug.Print Evaluate("MOD(17, 3)") -- HTH Bob Phillips "Stratuser" wrote in message ... I'm having trouble finding the MOD function. It doesn't seem to be accessible through WorksheetFunction. Anybody know how I can access it? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MOD function
What are you trying to do? I'm not sure why it doesn't appear in
WorksheetFunction's list, but it might have to do with the fact that VBA has a MOD function, e.g. MyRemainder = 19 MOD 5 To enter a formula in a cell via VBA use: ActiveCell.Formula = "=Mod(cell1, cell2)" Hope this helps KennyG "Stratuser" wrote in message ... I'm having trouble finding the MOD function. It doesn't seem to be accessible through WorksheetFunction. Anybody know how I can access it? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MOD function
VBA has a MOD operater
21 Mod 5 from the immediate window ? 21 Mod 5 1 I believe there is some operational difference for fractional arguments http://support.microsoft.com/default...b;en-us;214271 XL2000: MOD Function and Mod Operator Return Different Values http://support.microsoft.com/default...b;en-us;141178 XL: MOD Function and Mod Operator Return Different Values Just for interest: http://support.microsoft.com/default...b;en-us;225330 OFF2000: New Round Function in Visual Basic for Applications 6.0 Regards, Tom Ogilvy "Stratuser" wrote in message ... I'm having trouble finding the MOD function. It doesn't seem to be accessible through WorksheetFunction. Anybody know how I can access it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |