Paste Special Macro - can't undo

[Ben]

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

 

[JE McGimpsey]

Running the macro clears the Undo stack. See

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

for suggestions.

 

[Bob Flanagan]

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