Left out an important word.
Text should read...

"Undo does not work with macros"

Jim Cone


"Jim Cone" wrote in message ...
Undo does work with macros.
You have to write specific code to undo the macro.
One could give the user an option to undo -
say a button to click - then run the undo code.

Jim Cone
San Francisco, USA.

"DPW1" wrote in message
...
I can't undo after using a macro that does paste special formulas. Following
is the macro:
Selection.PasteSpecial Paste:=xlFormulas, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End