Hi dranreb

Make a copy of the worksheet
F5Special
Constants
OK
Delete the selection now

--
Regards Ron de Bruin
http://www.rondebruin.nl


"dranreb" wrote in message ...
I wanted to clear the values in a spreadsheet without deleting the formulas
or formatting in the spreadsheet. For example: A budget sheet made for every
year, the formulas and formatting remains the same, only the values change.
I tried paste special formulas....in this case, if values are present, they
get copied too.