Thread: MOD function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
KennyG[_3_] KennyG[_3_] is offline
external usenet poster
 
Posts: 1
Default 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?