<div>
Hi<br />
<br />
You could use this macro and call it for each sheet you want<br />
<br />

<pre><code id="code-20-40372412-1">Sub DeleteSheetContetn()
    Cells.Select
    Selection.ClearContents
    Range(&quot;A1&quot;).Select
End Sub</code></pre>
HTH<br />
Ivo Stoykov
</div>


Hi

You could use this macro and call it for each sheet you want



Sub DeleteSheetContetn()
    Cells.Select
    Selection.ClearContents
    Range("A1").Select
End Sub

HTH
Ivo Stoykov

<div>
Define &quot;clear&quot;? Do you want to keep headers (and if so, which rows), page setup? Are there formulas already set up?
</div>


Define "clear"? Do you want to keep headers (and if so, which rows), page setup? Are there formulas already set up?

<div>
Hi Phillip<br />
<br />
in this case I need to clear the sheets completely headers and all<br />
<br />
Regards
</div>


Hi Phillip

in this case I need to clear the sheets completely headers and all

Regards

<div>
Then both Rory's and Ivo's solutions both work.
</div>


Then both Rory's and Ivo's solutions both work.

<div>
As I need to clear so many sheets Rory's is the better solution for me, but thank you all for your input
</div>


As I need to clear so many sheets Rory's is the better solution for me, but thank you all for your input

<div>
<div class="content wysiwyg-content">
I have a file that has over 30 different worksheets. Some of these have data I need to keep but the majority have data that needs to be cleared so that we can start collecting the current data and post on the sheets.<br />
<br />
Could an expert provide me with VBA code that will clear data from all the sheets in the workbook except for those that I need to keep. There are currently 6 sheets that I need to keep so we can call them Sheet1, Sheet2 etc etc up to Sheet6<br />
<br />
Many thanks
</div>
</div>


I have a file that has over 30 different worksheets. Some of these have data I need to keep but the majority have data that needs to be cleared so that we can start collecting the current data and post on the sheets.

Could an expert provide me with VBA code that will clear data from all the sheets in the workbook except for those that I need to keep. There are currently 6 sheets that I need to keep so we can call them Sheet1, Sheet2 etc etc up to Sheet6

Many thanks

VBA to clear data from worksheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.