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