title: How do I use Excel VBA to filter 1 criteria across 2 columns?
body: <p>I have 2 columns of childrens' names in Column A and Column B. They represent pairs of children who have worked together.</p>
  
  <p>I want to filter for all rows where "Bob" has worked with any other kid.  So I want to filter for all rows for which 1 criteria (Bob) shows up in either Column A OR Column B.  </p>
  
  <p>I want to put these rows, or pairs of kids, into an array.  How do I do this?</p>