title: VBA if cell on sheet 1 matches a cell in column I on sheet 2 then?
body: <p>I'm trying to use a vba if statement to check if my cell H22 on sheet 1 matches a cell in column I on sheet 2.</p>
  
  <p>can someone please show me where im going wrong? Thanks</p>
  
  <pre><code>    If Range("H22").Value Like Worksheets("Sheet 2").Range("I1").Column Then
  
  MsgBox "Match"
  
  Else
  
  MsgBox "No Match Found"
  
  End If
  </code></pre>
  
  <p>It keeps telling me there is no match found so im guessing it cant find the matching cell value in column I on sheet 2</p>