Hi

Copy / PasteSpecial Values

Paste into the copied range and all formulas is turned into values.

Regards,
Per

"Arup C" skrev i meddelelsen
...
Hi,
Is there any process/macro by which I can convert the cells containing
formulas into values after a given period, for example I want after end of
month all the formulas will automatically convert into values. I have
workbooks of different months (sale of Jan 08, Sale of Feb 08 and so on),
which have the function TODAY, which keeps changing in the previous
month's
workbook. I want them to show the last date for the particular workbook
i.e.
31/01/08 for Sale of Jan 08 workbook, 29/02/08 for Sale of Feb 08
workbook.