Placing values in a range on a non-active sheet
Do I have to select a sheet before placing values in a range?
This works:
Sheets("Product").select
Range(Cells(1, 2), Cells(1, 11)).Value = 1000
This doesn't:
Sheets("Product").Range(Cells(1, 2), Cells(1, 11)).Value = 1000
Thanks in advance.
Daniel
|