HI I have this at the moment
Range("x3") = data1.Value
Range("x4") = data2.Value
and in ranges y3 to y4 I have this formula in them =mod(x3,0.25). what i want to do is instead of putting the data on to a spread sheet and then seeing if its 0 or .25 or.50 or .75 is there not a way i could just use some vb code.
I hope this is easly understanderable.
thanks in advance
Bookmarks