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 |
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 |
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 |
All times are GMT +1. The time now is 10:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com