Hello,
Seeking some help please. Novice at recording macro. I have pasted some data into worksheet one click on match destination formatting, and then started the macro recording. I then select all in the top left corner, copy and paste the same into worksheet two.
I then work through formulas and conditional formatting one worksheet one and then slightly different on worksheet two. It all seems to work when I record it.
However when I try to run it it gives me this message:
Run time error 1004
Paste method of worksheet class failed
When I have a look Activesheet paste is highlighted in yellow.

Selection.Insert Shift:=xlToRight
Range("C10").Select
ActiveCell.FormulaR1C1 = "RULEONE"
Range("C11").Select
ActiveSheet.Paste
With Selection.Font
.Name = "Arial"
.Size = 12
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With .


I haven’t pasted the full code as there is a lot of rows where I scroll which takes up lots of space.
Gil