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

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

Use Sendkeys to send the keystrokes. This keeps the undo buffer.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Ben" wrote in message
...
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