Resetting Spreadsheet Data Entry Cells

**acg** · 11-20-2007, 04:30 PM

Hi there,

I have a pretty big spreadsheet where data is entered everyday over a four-week period on 28 tabs (one tab for each day in a four-week period). The data is entered into the same cells on each tab. I would like to build some way of erasing all of the data that has been entered over the four weeks so that the spreadsheet can be 'started over' every four-weeks. Tried to record a macro of selecting all of the tabs then all of the cells and clearing them but the macro never seems to run. It gets hung up on the "Sheets(Array("1", "2" . . . " line. Any idea what I'm doing incorrectly? (Most of Code is below. Wouldn't fit it all in post).

Please Login or Register  to view this content.

**acg** · 11-21-2007, 11:53 AM

I apologize. Am new to code and forum. I will try to paste the code below in the 'code' tag which as far as I can understand what I did incorrectly the first time. Here goes:

Please Login or Register  to view this content.

**acg** · 11-21-2007, 11:53 AM

Was that right?

**royUK** · 11-21-2007, 12:47 PM

acg

Are you sure that you need all those tabs? Depending on the data it is more efficient to enter all data in one sheet then use a PivotTable on that data. However, if yo really need to do it your way why not simply set up a workbook as you want t then save it as a Template (*.xlt)?

Alternatively, protect all cells that you want to keep and protect the sheets then simply clear the unlocked cells

Please Login or Register  to view this content.

**acg** · 11-21-2007, 02:08 PM

Thanks Roy . . . the 'clear all unprotected cells' idea is what I actually needed. Seems to take a long time to run (around 30 minutes . . is that normal?). THanks much for the code!