Thread: Clearcontents
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Caroline vincent Caroline vincent is offline
external usenet poster
 
Posts: 9
Default Clearcontents

Good tip. it works. thanks a lot
-----Original Message-----

Range("A1:D500").SpecialCells(xlCellTypeConstants ,

23).ClearContents

Explore more on possibilities using the Edit Goto

Special menu while
recording macros.

HTH. best wishes Harald

"Caroline Vincent"

skrev i melding
...
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



.