clear picked cells

's Computer Specifications

to clear contents B3,B5,B7,B9, and so on this is every other cell up to B17
do you use comma as a seperator or what. I know it can not be a colon :
other sheets use d5: h60 not this one
Thanks

's Computer Specifications

One way:

Range("B3,B5,B7,B9,B11,B13,B17").ClearContents

In article <4A4BC180-2ADD-41D2-B113-(E-Mail Removed)>,
Curt <(E-Mail Removed)> wrote:

> to clear contents B3,B5,B7,B9, and so on this is every other cell up to B17
> do you use comma as a seperator or what. I know it can not be a colon :
> other sheets use d5: h60 not this one
> Thanks

's Computer Specifications

Thank You for the responce will use

"JE McGimpsey" wrote:

> One way:
>
> Range("B3,B5,B7,B9,B11,B13,B17").ClearContents
>
> In article <4A4BC180-2ADD-41D2-B113-(E-Mail Removed)>,
> Curt <(E-Mail Removed)> wrote:
>
> > to clear contents B3,B5,B7,B9, and so on this is every other cell up to B17
> > do you use comma as a seperator or what. I know it can not be a colon :
> > other sheets use d5: h60 not this one
> > Thanks
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup cells in one column and clear cells in another	JoshW0000	Microsoft Excel Programming	5	3rd Sep 2009 03:01 PM
Create a Clear button to clear unprotected cells	Jcraig713	Microsoft Excel Programming	2	26th Nov 2007 03:55 PM
clear contents cells of unprotected cells	=?Utf-8?B?RWQ=?=	Microsoft Excel Programming	6	12th Jan 2006 06:09 PM
Clear cells range if certain cells are all empty	gschimek - ExcelForums.com	Microsoft Excel Programming	6	13th May 2005 10:38 PM
RE: Counting a 'picked' range of cells where a < value is in the middl	=?Utf-8?B?QXNoaXNoIE1hdGh1cg==?=	Microsoft Excel Worksheet Functions	1	26th Jun 2004 06:23 AM