View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_6_] kirkm[_6_] is offline
external usenet poster
 
Posts: 156
Default Clearing a Sheet

On Tue, 17 Apr 2007 15:08:57 +1000, "Corey"
wrote:

You can use the :
.Cells.value =""
to keep the existing formatting


That worked, but also seems to keep the previous count
(which I want to lose).