title: How to find row number of cell containing special character along with alphanumeric characters?
body: <p>I have written code to get row number from the range("C:C") wherein I find matching value/text as that in cells(3,3).</p>
  
  <p>This code works as long as cells(3,3) has either pure number or pure text. But as soon as cells(3,3) has special character e.g.<em>~</em> <em>(as in MBGH3345~123)</em> the code returns error.</p>
  
  <blockquote>
    <p>run time error 400</p>
  </blockquote>
  
  <pre><code>Public Sub Find_Row_Number()
  
  Dim wb As Workbook  
  Dim ws As Worksheet  
  Dim FindCell As Range  
  Set wb = ActiveWorkbook  
  Set ws = ActiveSheet  
  
  Set FindCell = ws.Range("C:C").Find(cells(3,3))
  'value to be searched is in cells(3,3)
  
  If Not FindCell Is Nothing Then
      Msgbox (FindCell.Row)
  Else
      Msgbox ("Error")
  End If
  
  End Sub
  </code></pre>