title: Search for exact match of string in excel row using VBA Macro
body: <p>How do I search for a string in one particular row in excel? the I have the row index in a long type variable.</p>
  
  <pre><code>Dim rowIndex As Long
  rowIndex = // some value being set here using some code.
  </code></pre>
  
  <p>Now I need to check if a particular value exists in the row, whoose index is rowIndex.</p>
  
  <p>If there is match, I need to get the column Index of the first matching cell.</p>
  
  <p>I have tried using Match function, but I dont know how to pass the rowIndex variable in place of the cell range.</p>
  
  <pre><code>Dim colIndex As Long    
  colIndex = Application.Match(colName, Range("B &lt;my rowIndex here&gt;: Z &lt;my rowIndex here&gt;"), 0)
  </code></pre>