title: When trying to read #NAME? Value from excel to a string gives Type mismatch error
body: <p>I have a macro which reads a description string from excel and finds out the particular string is present in the data or not.</p>
  
  <p>Sometimes the input file might contain a value like #NAME? in the cell. When the macro reaches this cell its just gives error type mismatch Run time error 13 on the following line.</p>
  
  <p>I just wanted to ignore this line and continue the with the next line. How I should I give a validation (if). I'm using a 'do- loop until' for the loop. descriptionString is a string variable.</p>
  
  <pre><code>descriptionString = currentwrkbk.Worksheets(1).Cells(i, 1).Value
  </code></pre>