Pasting at a different location on another sheet

[Guzzlr]

Hello All
I have:

Sheets("ABC").Select
Columns("A:B").Copy
Sheets("XYZ"). _
Columns("A:B").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("A1").Select

This is working, however, I wish to paste in ("A3:B3") instead of Columns ("A:B")
When I try the recorder, I keep getting a warning that the copy area and the paste area are not the same size, which they are not. How can I copy all of A:B and paste in A3:B3 on sheet XYZ?
Thank you

 

[Peter_SSs]

How can I copy all of A:B and paste in A3:B3 on sheet XYZ?

You can't. As you have noted, the ranges are not the same size. All of columns A:B contains 1,048,576 rows. If you paste starting in A3 then you only have 1, 048,574 rows to paste into. It doesn't fit.
Presumably you don't mean copy the whole of columns A:B but copy all of A:B down to the bottom of any data? If column A determines the bottom of the data, then try ..

With Sheets("ABC")
  .Range("A1:B" & .Range("A" & Rows.Count).End(xlUp).Row).Copy
End With
Sheets("XYZ").Range("A3").PasteSpecial Paste:=xlPasteValues

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)