Copy PasteSpecial Values, will delete the formula and retain the result...

Vaya con Dios,
Chuck, CABGx3



"bouncebackability" wrote:


ok here goes...

what i was wondering is hard to explain so ill explain it in an small
example...

i have 3 sheets in my workbook, 'week1', 'week2' and 'total'

i enter the number 10 in cell A1 on the 'week1' sheet and the number 3
in cell B2 on the 'week2' sheet

on the 'total' sheet in cell C3 i enter the formula =week1!A1+week2!B2
and it adds it obviously.

but i then want to delete sheets 'week1' and 'week2' yet keep the value
13 in cell C3 on the 'total' sheet WITHOUT having to type it in myself.

ignore the macro part i would like to know just how to lock the values
to the cells.

is this even possible? im using excel 2000 but have access to 2003 if
necessary. any response would be wonderful :)

thanks in advance.




--
bouncebackability