Sending values from a range of cells on one worksheet to a range of cells on a different worksheet

Asked Jan 15 '21 at 16:32

Active Jan 15 '21 at 20:43

Viewed 20 times

I am getting the 1004 error when trying to send values from one sheet to another sheet in the same Excel 2016 workbook. Sheet A is the active sheet.

This code works

Sheets("A").Range(Cells(m+1,2),Cells(TgtRow-180,2)=Sheets("B).Range("B181:B363")

I've tried several variations of the code I'd like to get to work, but resorted to try and get this to work

Sheets("A").Range(Cells(m+1,2),Cells(TgtRow-180,2)=Sheets("B).Range(Cells(183,2),Cells(363,2)

to try and figure out where I am going wrong. Should be the same as using the other notation, but I'm still getting the 1004 error. I'm sure it is a simple fix, but I can't find it. Thanks for your help!

edited Jan 15 '21 at 20:43

braX

11,506
5
20
33

asked Jan 15 '21 at 16:32

Wamo

please disregard the missing ) and the end of the faulty code string. – Wamo Jan 15 '21 at 16:34
1

`Cells` needs a worksheet qualifier, or it defaults to the active sheet. – Tim Williams Jan 15 '21 at 16:42

Sending values from a range of cells on one worksheet to a range of cells on a different worksheet

0 Answers0