Try recording a macro as you perform the action manually. That's a good way
to start learning the Excel object model.

--
Jim
"Secret Squirrel" wrote in
message ...
| 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?