title: Macro for Copying Specific Cells within a range to clipboard
body: <p>I want to create a button to activate a macro in Excel which searches specifically in the range F10;F14. Within this range are either names or "NA". I want the macro to search for names only placing them in my clipboard and disregard the "NA" within the range. </p>
  
  <pre><code>Sub Macro4()
  '
  ' Macro4 Macro
  '
  
  '
      Range("F10:H16").Select
      Selection.Copy
  End Sub
  </code></pre>