Making VB PasteSpecial method to work the same as Excels Application

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am using the following code to paste data in my worksheet
Selection.PasteSpecial Paste:=xlValues
When I use this method the undo button became disabled, so I cannot be
able to undo the pasting.
If I use the Excel's PasteSpecial command the undo button is enabled
and I can be able to undo the changes.

How can I make the undo button be enabled so that I can undo the paste
done using PasteSpecial method?

Thank you
John
 
Thanks Trevor for your answer.
I had a problem with pasting and validation, thats why I decided to
use VBA PasteSpecial, so that I only paste values and not validation.
I have now put code to reset validation in WorkSheet_Change procedure.
But the Undo and Repeat buttons are showing the word "validation" in
their lists
How do I remove this word "validation" from the list.

Thanks

John
 
Back
Top