Deleting all cells after finished with Data

[jrf001]

Hi Team,

I have a spreadsheet with lots of data that runs for 10 days. I would like to know if after the 10 days I can push a command buttoin and all the cells that contain data can be deleted. There is other data on the spreadsheet that I don't want deleted, like column/row headers etc

Any quick ideas for someone not real familiar with vba or command buttons

cheers Jason

 

[Legacy 98055]

Hi
There are various ways to determine what range needs to be cleared. I would simply choose the largest range expected and then add a bit to that...
Simple syntax for a macro or command_click event on a command button would be as such:

Range("A1:H65000").ClearContents

Tom