I am having a proble with this code and I keep getting an error. I want to clear the contents of the page and then paste what was copied from another page to the new one. Is there an easier way?
I forgot to add where I wanted it to paste to.
![]()
'Paste to new Sheet Sheets("Pend-PC Acc").Select Cells.Select Selection.ClearContents Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False
Bookmarks