Delete all data on Worksheet?

[HotRod]

Is there a better way to delete all the data on a worksheet than.

Application.Worksheets("WORKSHEET").Range("A1", "Z55500").Value = ""

 

[Bryan Loeper]

Is there a better way to delete all the data on a worksheet than.

Application.Worksheets("WORKSHEET").Range("A1", "Z55500").Value = ""

Quick'n'dirty:

Application.Worksheets("WORKSHEET").Delete
Application.Worksheets.Add("WORKSHEET")

 

[Gord Dibben]

ActiveSheet.Cells.ClearContents

OR specific sheet

Sheets("Sheetname").Cells.ClearContents


Gord Dibben MS Excel MVP

 

[HotRod]

Thanks Gord This is what I needed "Sheets("WORKSHEET").Cells.ClearContents"