Hi people,

easy one i'm sure for you talented lot,

i want to change a load or ranges all to the same number withouth having to select one at a time then change the value.

how do you enter loads of ranges together?

i have seen it done before just can't remeber how:

Range("a1,a2,a3,a4").value = week
should be like above but don't know how to get it to work!!

Cheers for reading and any help