Is there a way to disable UNDO in Excel 2000? I am using VBA to copy formulas from the first row of 137 columns to the following 2,600 rows. A dialog box pops up with the message that there is not enough memory...continue without undo? The copying can be completed, but I would like to know is there is a way in VBA to turn UNDO off and back on again after the copying is finished. My goal is to speed up the copying that now takes several minutes.

Thanks.

Jerry

Jerry,

How about:

Application.DisplayAlerts = False
'Your code....
Application.DisplayAlerts = True

Kind regards,
Dennis