Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

Cells.Clear

Hi,

Worksheets("Sheet1").Cells.Clear
will clear the sheet.

If there a way that we can clear Cells less defined range?

some thing like Cells excluding "MyRange" .clear? so that t will be so
fast and without using loop

thanks

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
Create a Clear button to clear unprotected cells	Jcraig713	Excel Programming	2	November 26th 07 03:55 PM
Cells.Clear	Ben Dummar	Excel Discussion (Misc queries)	3	January 24th 07 10:50 PM
Clear cells	One-Leg	Excel Programming	3	June 3rd 06 12:20 AM
clear contents cells of unprotected cells	Ed	Excel Programming	6	January 12th 06 06:09 PM
Clear cells range if certain cells are all empty	gschimek - ExcelForums.com	Excel Programming	6	May 13th 05 10:38 PM

All times are GMT +1. The time now is 03:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us