title: VBA Clear cells in named range that contain specfic character
body: <p>All,
  I'm am completely unfamiliar w/ VBA, but want to get a code for a fantasy football draft simulation that will "reset" the draft selections.</p>
  
  <p>Parameters: the size of the data is 12 teams (columns), and 18 rounds (rows). The data is not adjacent, so I named the the range that I want to reset "DataVal"</p>
  
  <p>The league is a keeper league which means that there are players already in selected cells prior to the draft, so I don't want those cleared. To differentiate between kept and unkept players, the unkept players have their positions in parentheses.</p>
  
  <p>Request: I want a code that clears all cells containing "<strong>(</strong>" <em>or if that's not possible, "(RB)" , "(QB)" , "(WR)" , "(TE)" , "(TD)" , "(PK)"</em> within range "DataVal"  which I can attach to a Button</p>