Grace, one way to get the required statements is just to record a macro of
the action.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Grace" wrote in message
...
Some of my macros seem to be slowed down by having to calculate after each
operation and this is not necessary. So, initially, I want to disable
calc
and do it only once at the end. What is the best macro command for this?

Thanks,
Grace