Hi JE. I've always thought that this was an odd ball one because "Excel
specifications and limits" says that the number of Undo levels is 16. One
would normally think of this as being fixed. I think I'll send a suggestion
to Microsoft to update "Excel specifications and limits" to say something
like "default is 16, see kb article Q211922 to change it. To bad there
isn't a Reg hack to increase the number of Columns beyond 256. :)

Just for discussion, I have experimented in the past by setting Undo
history to low values to see if there was any noticeable speed differences.
I didn't like setting it to 0 because it turned Undo off. I did not notice
any real timing differences by setting it to a low value of say 1-3. I did
have it set at 10 for awhile, but with Excel 2003, I'm back to the default
setting of 16.

This is one of the few references that talk about Undo while running a
macro...
"...This feature (Undo) is disabled for optimization and performance
when you run a macro. ..."

It would be interesting if the OP posted back on any noticeable performance
changes if he increases the Undo levels to a high number.

--
Dana DeLouis
Win XP & Office 2003


"JE McGimpsey" wrote in message
...
In article ,
Gord Dibben <gorddibbATshawDOTca wrote:

See Dana's post.

Glad I wrote AFAIK - I'd forgotten that if I ever knew it. Thanks!