title: Find Column Header By Name And Select All Data Below Column Header (Excel-VBA)
body: <p>I'm attempting to create a macro to do the following:</p>
  <ol>
  <li>Search a spreadsheet column header by name.</li>
  <li>Select all data from the selected column, except column header.</li>
  <li>Take Number Stored As Text &amp; Convert to Number.</li>
  </ol>
  <ul>
  <li>Converting to Number to use for VLookup.</li>
  </ul>
  <p>For Example:</p>
  <p>Visual Spreadsheet Example:</p>
  <p><a href="https://i.stack.imgur.com/NaGXV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NaGXV.png" alt="enter image description here" /></a></p>
  <p>I've discovered the following code online:</p>
  <pre><code>With ActiveSheet.UsedRange
  
  Set c = .Find(&quot;Employee ID&quot;, LookIn:=xlValues)
  
  If Not c Is Nothing Then
  
      ActiveSheet.Range(c.Address).Offset(1, 0).Select
  End If
  
  End With
  </code></pre>
  <p>However, I'm still experiencing some issues.</p>