View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
Posts: 3,872
Default 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?

Range("A1:C10").SpecialCells(xlCellTypeConstants). ClearContents

Claus B.
Microsoft 365 for business