I have a couple of ranges in one sheet that I want to copy to a new sheet using VBA. So I have range1, range2 and range3 which I want to copy to columns A, B, C in the new sheet. I can do this:
select source sheet
select range
copy range
select destination sheet
select cell A1
paste
But how do I accomplish the same thing in one line without selecting the sheets?
Sheets("Sheet1").Range.Copy .Sheets("Sheet2").Range("A1")
select source sheet
select range
copy range
select destination sheet
select cell A1
paste
But how do I accomplish the same thing in one line without selecting the sheets?
Sheets("Sheet1").Range.Copy .Sheets("Sheet2").Range("A1")