EXCEL VBA Questions and Answers

How do you check the Calculation state ?

Pretty simply, using the Application.CalculationState property which tells if calculation has completed ( xlDone ), is pending ( xlPending) , or is in process ( xlCalculating ).