| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear Area Except Formulae
Is there a way to select a range and clear all content not a formula in
that range? -- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Clear Area Except Formulae
Hi Duane,
Am Wed, 19 May 2021 12:45:59 -0500 schrieb dpb: Is there a way to select a range and clear all content not a formula in that range? e.g.: Range("A1:C10").SpecialCells(xlCellTypeConstants). ClearContents Regards Claus B. -- Windows10 Microsoft 365 for business |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File, print area, clear area, is not working | New Users to Excel | |||
| When I clear a print area, it still prints. | Excel Worksheet Functions | |||
| Can't Clear Print Area | Excel Discussion (Misc queries) | |||
| How do I clear the formating of the area OUTSIDE my chart on my w. | Excel Discussion (Misc queries) | |||
| Clear formulae | Excel Programming | |||
Linear Mode
