Mod in VB code

[Rocky0201]

Hi...

I have a value in RowCount that once I divide it by 3, if there is a remainder then add 1 to RowCount. The following test formula works however, I am trying to accomplish the same in VB. In my VB, the N1 in the formula below would be my RowCount.

=IF(MOD(N1,3)<>0,INT(N1/3+1),INT(N1/3))

Thanks for the help...

 

[tusharm]

VBA has a Mod operator rather than Excel's MOD function. Use it as A Mod B. For more search Excel VBA help for 'mod' (w/o the quotes).