I'm not sure exactly what you're after but try this:
Sheets("Sheet1").Cells.ClearContents

Charles Chickering

jk wrote:
I have a sheet which contains a several data validation dependant lists which
will be used amoung several people from distant locations.They will fill in
all the fields and submit the sheet to other departments. I would like to
create a control such as a button which would delete all data after
information has been submitted so a blank sheet can be used several times
without affecting the validation lists.Is this possible?