Clear Contents of multiple pages in my workbook

[nickmessick1]

Do I need to use a macro/VBA to automatically clear the contents of multiple pages. Is there an easy way to accomplish this I should say. Every month I clear about 20 pages worth of data and it would be easier to clear all the cells at once. Any help? Thanks.

[arlu1201]

Yeah, a small macro should do your work.

What do you want to be done exactly? Just clear the contents of all the sheets in your file? Should the headers be left intact?

Is it only for one file or multiple files in a folder?

[patel45]

How can I know what are the pages to be deleted ? to delete all on sheet(1)
sheet(1).cells.clearcontents

[Norie]

You can do this manually.

Select the first sheet in the workbook, then while holding down SHIFT select the last sheet.

Then select all the cells on the active sheet by clicking in the top left.

Finally hit DELETE.

[nickmessick1]

I would like to clear all the contents on 20 tabs of one worksheet. I would like to leave headers intact. Any recommendation for a small macro?

[arlu1201]

Try this

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

[nickmessick1]

Worked Great!! Thanks.