Posted to microsoft.public.excel.programming

kirkm[_6_] kirkm[_6_] is offline

external usenet poster

Posts: 156

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).

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
clearing data from excell sheet	A	Excel Discussion (Misc queries)	3	January 28th 08 04:09 PM
Clearing data from a so called protected sheet???	funkymonkUK[_162_]	Excel Programming	5	May 17th 06 05:16 PM
my macro is clearing the wrong sheet	Polarbear	Excel Programming	6	August 2nd 05 08:49 PM
Clearing old data from a sheet	5lmustang[_2_]	Excel Programming	0	October 26th 04 12:18 AM
Clearing old data from a sheet	5lmustang	Excel Programming	1	October 20th 04 02:17 AM

All times are GMT +1. The time now is 08:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us