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