Clearcontents

[Caroline Vincent]

Does anyone know how to clear the content of a range
without deleting the formulae?
Range(XXX).clear or Range(XXX).clearcontents delete the
formulae as well.
Thanks

 

[Harald Staff]

Range("A1500").SpecialCells(xlCellTypeConstants, 23).ClearContents

Explore more on possibilities using the Edit > Goto > Special menu while
recording macros.

HTH. best wishes Harald

 

[caroline vincent]

Good tip. it works. thanks a lot

-----Original Message-----

Range("A1500").SpecialCells(xlCellTypeConstants, 23).ClearContents

Explore more on possibilities using the Edit > Goto > Special menu while
recording macros.

HTH. best wishes Harald

"Caroline Vincent" <[email protected]> skrev i melding



.