jolivanes
11-24-2009, 08:01 PM
Following is part of code I am using
Set myrange = Range("H2", Range("H" & 3 + 360 / Range("G4").Value))
I would like to have a MsgBox pop up when 360 is divided by G4 and the result is anything else than a whole number, a number with 0.25, 0.5 or 0.75. That would be a MsgBox with a warning to use a different number and then Exit Sub.
I tried with MOD but that does not work at all (for me)
Could someone help me with this.
Thanks in advance
Regards
John
Set myrange = Range("H2", Range("H" & 3 + 360 / Range("G4").Value))
I would like to have a MsgBox pop up when 360 is divided by G4 and the result is anything else than a whole number, a number with 0.25, 0.5 or 0.75. That would be a MsgBox with a warning to use a different number and then Exit Sub.
I tried with MOD but that does not work at all (for me)
Could someone help me with this.
Thanks in advance
Regards
John