Deleting all cells after finished with Data

jrf001 · Apr 22nd, 2002, 05:04 AM

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

Tom Schreiner · Apr 22nd, 2002, 05:43 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 05:04 AM	#1
jrf001 New Member Join Date: Mar 2002 Posts: 19	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

Apr 22nd, 2002, 05:43 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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