Getting Excel to Recaclulate IF Macro

[mcphatt]

Hi everyone,

I have a macro button which calculates the active sheet, which is fine, but sometimes the division which the sheet is doing throws up a solution which is not an integer. So, I was wondering if I can put an if statement into the macro code to tell excel to keep calculate until it returns an interger.

Essentially I want:

IF F12<>INT THEN ActiveSheet.Calculate

but I don't know how to put this in code form.

Thanks

 

[VoG]

Maybe like this

Do Until Range("F12").Value = Int(Range("F12").Value)
    Calculate
Loop

 

[mcphatt]

Thanks so much, that is perfect!!