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