Hi Wobbly,

I guess that an archieved page shoul never change.
I suggest that you use Paste Special -- Value when copying the
contents of Sheet1 to an archive sheet.
In this way the calculated results will be copied and not the
formulas.
Ideally you add protection to the archive sheet so a special action
must be done before the sheet can be changed.


HTH,

Woouter