Thanks for the help. I'm always learning. Otto
"Frank Kabel" wrote in message
...
Otto Moehrbach wrote:
Frank
Correct me if I'm wrong but doesn't the VBA Mod function round
all
numbers before it does the division? As I understand it, the VBA
mod, as in "somenumber Mod 1" will always return zero regardless of
what "somenumber" is. Thanks for your help. Otto
"Frank Kabel" wrote in message
...

Hi Otto
you're right. It uses only the integer values for the division
(according to the Excel helpfile)

Frank