Clear all cell in a sheet
 

Hi!!
I need some way to clear all
cell in a sheet.

Hope someone can help

Alvin

Clear all cell in a sheet
 

Hi Alvin,

Try:

Sheets("YourSheetName").Cells.ClearContents


---
Regards,
Norman



"Alvin Hansen" wrote in message
...
Hi!!
I need some way to clear all
cell in a sheet.

Hope someone can help

Alvin

Clear all cell in a sheet
 

try

Sub clearcells()
Worksheets("sheet13").UsedRange.Clear
End Sub

--
Don Guillett
SalesAid Software

"Alvin Hansen" wrote in message
...
Hi!!
I need some way to clear all
cell in a sheet.

Hope someone can help

Alvin