Change Multiple ranges in one go

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:

Please Login or Register  to view this content.

should be like above but don't know how to get it to work!!

Cheers for reading and any help

Try

Please Login or Register  to view this content.

VBA Noob