| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing cells
Other than a tedious looping construct, how can you
quickly clear a large block of cells? TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clearing cells
Selection.Clear
Selection.ClearContents Range("A1:A100").Clear Range("A1:A100").ClearContents Clearcontents will only clear the value in it Clear also the formatting -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "hal" wrote in message ... Other than a tedious looping construct, how can you quickly clear a large block of cells? TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clearing cells
Hal,
Try something like Range("A1:Z10000").Clear Or do you have something else in mind? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "hal" wrote in message ... Other than a tedious looping construct, how can you quickly clear a large block of cells? TIA |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clearing cells
Range("A1").CurrentRegion.ClearContents
Regards, Tom Ogilvy "hal" wrote in message ... Other than a tedious looping construct, how can you quickly clear a large block of cells? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
| VB Code for clearing Cells | Excel Discussion (Misc queries) | |||
| clearing cells | Excel Worksheet Functions | |||
| Clearing unlocked cells | Excel Discussion (Misc queries) | |||
| Clearing Cells | New Users to Excel | |||
Linear Mode
