| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear picked cells
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear picked cells
One way:
Range("B3,B5,B7,B9,B11,B13,B17").ClearContents In article , Curt 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear picked cells
Thank You for the responce will use
"JE McGimpsey" wrote: One way: Range("B3,B5,B7,B9,B11,B13,B17").ClearContents In article , Curt 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear cells | Excel Programming | |||
| Clear cells | Excel Programming | |||
| clear contents cells of unprotected cells | Excel Programming | |||
| Clear cells with #N/A | Excel Programming | |||
| Clear cells range if certain cells are all empty | Excel Programming | |||
Linear Mode
