| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear all cell in a sheet
Hi!!
I need some way to clear all cell in a sheet. Hope someone can help Alvin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
| Transfer a name from one cell to another but leave clear if clear? | Excel Worksheet Functions | |||
| Clear a set of combo boxes after a Submit of data to a new sheet. | Excel Worksheet Functions | |||
| Code to clear sheet | Excel Programming | |||
| Macro help - copy row, clear, and paste on different sheet | Excel Programming | |||
![Alvin Hansen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
