Thread: Delete all data on Worksheet?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 = ""


Reply With QuoteReply With Quote