Paul Sheppard Wrote:
Hi Duca

You could record a macro, as follows:

Tools Macro Record New Macro In Macro Name give it a name (no
spaces eg ClearData) Click OK now every key stroke / mouse click
you make will be recorded, so select the cells you want to clear data
from right mouse click and click on clear contents Tools Macro
Stop Recording


Many thanks for all of your help. From all of your answers I was able
to fulfill what I wanted and now I have a button on my sheet that the
users can use to delete all of the old information. I just love
learning!

Duca


--
Ducatisto
------------------------------------------------------------------------
Ducatisto's Profile: http://www.excelforum.com/member.php...o&userid=26976
View this thread: http://www.excelforum.com/showthread...hreadid=401879