| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 = "" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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") |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 = "" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete all data on Worksheet?
Thanks Gord This is what I needed "Sheets("WORKSHEET").Cells.ClearContents"
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete rows of data permanently from a worksheet after filt | New Users to Excel | |||
| Can I delete the data and keep formulas for a whole worksheet? | Excel Worksheet Functions | |||
| How do I delete data in worksheet, but not the associated formula | Excel Worksheet Functions | |||
| Delete all data on a worksheet | Excel Worksheet Functions | |||
| how do I delete data from a worksheet without deleting the formul. | Excel Discussion (Misc queries) | |||
Linear Mode
