Starting with something in the system clipboard, a macro I am trying to use pastes the contents of the clipboard to an area on my worksheet. The paste is successful unless I first clear the contents of the area. The clear apparently deletes the contents of the clipboard and the paste gives an error. The commands I am using in the macro to do the paste:
Range (“A1:D200”).select
Selection.ClearContents
Range(“A1”).Select
ActiveSheet.paste
Is there a command that I can use that will clear the contents before doing a paste but still allow successful completion of the paste?
Bookmarks