Delete all data on Worksheet?
 

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

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

Delete all data on Worksheet?
 

On May 15, 2:29 pm, "HotRod" wrote:
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")

Delete all data on Worksheet?
 

ActiveSheet.Cells.ClearContents

OR specific sheet

Sheets("Sheetname").Cells.ClearContents


Gord Dibben MS Excel MVP

On Tue, 15 May 2007 14:29:19 -0400, "HotRod" wrote:

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

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

Delete all data on Worksheet?
 

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