In a brief experiment, this worked for me:
Copy the range having the data to Sheet2
Now copy the formulas to Sheet2
Finally Cut and Paste the Data from Sheet2 back to Sheet1
best wishes & Merry Christmas
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Railrd" wrote in message
...
Have two worksheets. On sheet 1 in cell D48 have the following formula:

=SUM((D9C9), (F9E9), (R9Q9), (Z9Y9), (AD9AC9), (AF9AE9), (AH9AG9),
(AN9AM9), (AP9AO9), (AR9AQ9), (AX9AW9), (BB9BA9), (BD9BC9),
(BF9BE9),
(BN9BM9), (O3P3), (O4P4), (O10P10), (O14P14), (O16P16), (O17P17),
(O18P18), (O21P21), (O22P22), (O23P23), (O26P26), (O28P28),
(O29P29),
(O30P30), (O34P34))

I would like to move it to a cell in sheet 2 but is there a way yo do this
quickly so I don't have to insert 'Sheet 1'! in front of every cell used
in
the formula. It wouldn't be bad but I have to move about fifteen or so
formulas with various amount of variables (cells).