question

Adrisan-0795 avatar image
0 Votes"
Adrisan-0795 asked Viorel-1 edited

Copy paste VBA

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

office-vba-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Viorel-1 avatar image
0 Votes"
Viorel-1 answered Viorel-1 edited

Try this:

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.