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
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)