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