title: Searching for a non-numeric value in VBA Excel
body: <p>I'm using VBA in Excel to try and write some macros, however, I am very new to the process.</p>
  
  <p>At the moment, I am trying to use a for loop to search a column for a non-numeric value. To do this I wrote the following:</p>
  
  <pre><code>rwcnt = WorksheetFunction.CountA(Range("A:A"))
  Dim i As Integer
  
  For i = 1 To rwcnt
      If Cells(i, 1).Value = Not IsNumeric Then
          Cells(i, 1).Select
          Range(Selection, Selection.End(xlDown)).Select
          Exit For
      End If
  </code></pre>
  
  <p>This is returning an error saying that the argument is not optional and it highlights IsNumeric.</p>
  
  <p>What I'd like to accomplish is to search column A and select the first cell that contains non-numeric characters in it outside of my headers. Also, this is searching through >100K cells so if there is a less intensive way to do this process, suggestions would also be nice.</p>
  
  <p>Any help would be appreciated and again, I don't know much at all about this stuff so if everything is wrong, feel free to say so.</p>