Running the macro clears the Undo stack. See

http://www.j-walk.com/ss/excel/tips/tip23.htm

for suggestions.

In article ,
Ben wrote:

Hi there,

I have recorded a very simple macro to perfom the 'Paste Special' function
but noticed that I can't undo my last action using this macro.

Can anyone help?

Macro:
Sub PasteVal()
Selection.PasteSpecial Paste:=xlValues
End Sub