.
Quote Originally Posted by FDibbins View Post
......
and this does not work ...
Sheets("Sheet2").Range(Cells(2, 2), Cells(4, 4)) = 50
......
....wot Romper and Jindon said, I learnt the hard way like you just did, but...

. - To do it in a similar way to wot you want, this works

Sheets("Sheet2").Range("B2", "D4") = 50
.. and you can combine the two, which i have found useful if for example with the second cell you need to use the cells bit, when, for example, you must use a variable for the last column. - If you know the first cell is fixed you can simplify half of it .

 lc = 4
Sheets("Sheet2").Range("B2", Sheets("Sheet2").Cells(4, lc)) = 50
.. and you probably know, or can guess, if the last row is the issue with the need to use a variable, then it stays simple

 Let lr = 4
Sheets("Sheet2").Range("B2", "D" & lr & "") = 50

. Alan

Edit:
P.s. you could check this out to get all that stuff a bit clearer:
http://excelmatters.com/referring-to-ranges-in-vba/