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.