>In various situations, eg 'pasting', when handling very large blocks of
>data, Excel gives a message like 'Not enough memory to undo -OK to
>continue?'.
>
>Does anyone know whether anything can be done for any of the three (a), (b)
>or (c) above please?
>
>
>Geoff Smith
>
>


To give Undo more memory, buy more RAM but that may not be practical across
a lot of machines on which your application runs.  To supress the message,
before your code that starts pasting place Application.DisplayAlerts = False
then after it Application.DisplayAlerts = True.  I am not positive if this
will work for this condition or if it will unload undo if the message is
skipped as the default may be not to unload and abort the paste.  There is
no command that I am aware of that can shut off Undo for Excel.

HTH...Robert