If you give a man a fish you feed him for one day. If you teach him to fish
you feed him for a lifetime.

--
Jim
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
| Sub todostuff()
|
| Application.Calculation = xlManual
| your code here
| Application.Calculation = xlAutomatic
|
| End Sub
|
| On Tue, 20 May 2008 07:20:01 -0700, Secret Squirrel
| wrote:
|
| How can I toggle on and off the automatic calculations in VBA code? I
have a
| code that imports data from another file but when I run this code I want
to
| be able to shut off the auto-calc until the import is done. How would I
do
| this?
|