| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear a sheet
Simply:
Public Sub ClearSheet(sheet As Worksheet) sheet.Cells.Clear End Sub I would change the variable sheet though as I think it is a reserved word. RBS wrote in message oups.com... Seek clean alternative to : Public Sub ClearSheet(sheet As Worksheet) sheet.Activate Cells.Select Selection.ClearContents Selection.Clear End Sub Thanks. |
| 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) | |||
| msg box to clear a sheet | Excel Programming | |||
| How to Clear all Data on sheet after a given row | Excel Programming | |||
| Clear all cell in a sheet | Excel Programming | |||
| Code to clear sheet | Excel Programming | |||
Threaded Mode
