ExcelBanter - Clear Area Except Formulae

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Clear Area Except Formulae (https://www.excelbanter.com/excel-discussion-misc-queries/455160-clear-area-except-formulae.html)

dpb

Clear Area Except Formulae

Is there a way to select a range and clear all content not a formula in
that range?

--

Claus Busch

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

All times are GMT +1. The time now is 09:48 AM.