title: Mismatch during if-statement
body: <p>I am slowly learning VBA here and I seem to be running into a mismatch problem. The goal is to find the row that I am working on i.e "Current" and then autofill the information on the second sheet in specific cells. From using the debugger, the issue seems to be inside the if-statement. Any help is appreciated!</p>
  
  <p>I tried to go through and change the cell type in the sheet itself. Also tried using .Range instead of .Cells (assuming I am even doing that correctly.</p>
  
  <pre><code>Private Sub Workbook_Open()
  
  Dim i As Integer, LastRow
  
  'Find the last row in the Information sheet
  'LastRow = Sheets("Information").Range("A" &amp; Rows.Count).End(xlUp).Row
  
  For i = 3 To 1000 'Check rows 3 through the last one
  
      If Sheets("Information").Cells("A", i).Value = "Current" Then 'Check what row has current
          Sheets("Scorecard").Range("B3") = Sheets("Information").Cells("A" &amp; i) 'Input the name in the scorecard
  
          End If
  
      Next i
  
  
  End Sub
  </code></pre>
  
  <p>Error states</p>
  
  <pre><code>Run-time error '13'
  Type Mismatch
  </code></pre>