On Jun 27, 10:32*am, Xt wrote:
Hi folks.

Is there a way to turn the calculation of a particular sheet off and
on using VBA while the VBA is working with data from another sheet?

Thanks

xt


Hi!

First use this "Application.Calculation = xlCalculationManual" and in
End "Calculate"

Hope it will help!
~jaeson