Playing around trying to learn Range Objects (still having a hard time learning VBA stuff lol)
I can input data into cells on active WS using this...
and this...
Range("J1:L4") = 8
and this...
Range(Cells(2, 2), Cells(2, 2)) = 7
Then I started putting data into a different sheet...
Sheets("Sheet2").Range("A1") = "ccc"
These all worked as expected.
Then I tried to use the Cells() command on a different sheet and got an error message
Sheets("Sheet2").Range(Cells(2, 2), cells(4,4) = 50
I get a syntax error
What am I doing wrong?
Bookmarks