title: Selecting specific check boxes using a master check box
body: <p>I am trying to create a macro to select all check boxes of a certain column.
  For example I have 10 criteria check boxes per column with master check box for each column as "select all". 
  I have the code down to select EVERY check box but cannot figure out how to tweak it slightly to only select or deselect cells A2:A10 for example, and not the boxes in column B, C, etc.</p>
  
  <p>I'm using this simple script;</p>
  
  <pre><code>Sub SelectAll_Click()
  Dim CB As Checkbox
  For Each CB In ActiveSheet.CheckBoxes
  If CB.Name &lt;&gt; ActiveSheet.CheckBoxes("Check Box 1").Name Then
  CB.Value = ActiveSheet.CheckBoxes("Check Box 1").Value
  End If
  Next CB
  End Sub
  </code></pre>
  
  <p>I tried unsuccessfully altering the &lt;,>, = of the check box name to identify say anything less than the first checkbox of column B
  As well as adding in an =range()</p>
  
  <p>I am brand new to all of this and I'm sure with time and learning I'll look back and laugh at my road block here, but if anyone could lend me their expertise for the time being, it'd be greatly appreciated.</p>
  
  <p>Thanks</p>