W

#### Walter

I have been trying to copy some formulas from a tab to another in the same

worksheet. what i want to do is to keep the original references of the

formulas. If i do a simple copy and paste, the resulting formulas will point

to different cells.

One way i devised to overcome this was to

1) cut and paste the formulas into the other tab

2) change all formulas into strings

3) copy strings back to the original place

4) back from strings to formulas

but this has the negative effect that all other cells linking to the ones i

cut, will be re-referenced to the new ones, that is something i dont want.

I hope this is not too confusing, but is there any way to copy formulas and

keep where they originally pointed to?

many thanks for your help!!