easy one about a formula

[shadow12345]

Hi,

This is pretty simple but im wondering something. I have written a formula that refers to a range of cells a number of times (i havent used a named range).

When i edit the formula to expand the range i just drag the box around the cells i want.

Heres my question.... can i move all of the highlights around the range at once? or do i have to do them all individually.

 

[shg]

One at a time.

 

[shadow12345]

bugger.... ok ill guess ill just stick with find and replace then. (and remember to name the range next time)