Excel Made Easy

Vba clear the contents of an entire sheet in Excel

How to clear the contents of an entire sheet.

i want to delete the contents of the sheet1. without deleting the sheet.

Answer:

To clear the sheet use : Sheet1.Cells.Clear

(for formulas, depending on your country, you might have to change ; with , or the opposite

You can find similar Excel Questions and Answer hereunder

1) How can I prevent users from seeing / accessing my macro code?

2) How do I add a shape using VBA?

3) How can I clear cell after activating a routine when there is a change in value of a cell?

4) How can I remove display of Gridlines in my worksheet using VBA?

5) How to do webscrapping in VBA. Here some basics

6) How do I update my DropDown list whenever the sheet is activated?

7) How can I get input from user through a prompt and assign user's input to a cell?

8) How can I set the fill color, font color and set number format of cell to date?

9) How to concatenate strings in vba in Excel

10) How can I dynamically add series to an existing chart using VBA?