How to clear Contents in Multiple Sheets using VBA | Clear data in Multiple Sheets

In this Excel VBA Tutorial, I'm teaching you how to clear Contents from Multiple worksheets in one single click or how to clear data from multiple worksheets in one single click using VBA Macro

[excelforeveryone]

Really a helpful. Thanks a lot for sharing.

[WayneShawtky]

I have multiple worksheets with data in different specific cells on each sheet. I wat to have the clear, or reset button on the dashboard page to clear values so I can start the new entry. How do you create a Macro for this?

[hmnite]

How do you clear from some of your worksheets but not all of them. This works great on clearing all 18 sheets, but I only want to clear 15 of the sheets.

Thank you,

[martincommunications]

Thank you! I am new to macros and that was excellent. I have a question. I have Sheet 1 and I do not want anything cleared there, but I want range c7:n1000 to clear from sheets 2 through 11. What would be the code for that? Thank you in advance.

[AT_Eng]

how to clear a cell range except those which has formula in it.?

[saifnawaz]

Hi, how can I clear content in multiple sheets in one go.

[mayurgupta]

i want to clear content of every sheet except the first one :
My code is somethings like this but it shows an error, please help out
Dim x As String
Dim ws As Worksheet
For Each sht In wbook.Worksheets
'
If ws.Name <> "Instructions" Then
sht.Activate
sht.Cells.Select
Selection.ClearContents
Selection.ClearFormats ' edit: clear formats too
sht.Cells(1, 1).Select ' edit: select the first cell to cancel selection of the whole sheet
End If
Next

[HLDENSUX]

How do you clear all the tabs rather than just the one?

[art_craft]

It's not multiple sheets, you cleared one sheet only.