1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Clear Area Except Formulae

    From dpb@21:1/5 to All on Wed May 19 12:45:59 2021
    Is there a way to select a range and clear all content not a formula in
    that range?

    --

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Wed May 19 20:02:05 2021
    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)