Copy paste VBA

Question

I am trying to paste to a defined object but it is not working, any help please!

Sub Macro_RBC()
Dim rng As Range
Set rng = Worksheets("RBC OA").Range("B1").End(xlDown).Offset(1, 0)

Range("A1:D10").Copy _
Destination:=Worksheets("RBC OA").rng

Answer 1

Try this:

 . . .
 Range("A1:D10").Copy Destination:=rng