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?