title: Excel VLookup "Object Required" Error
body: <p>Here's another one of those "so simple it's maddening when it doesn't work" type questions.</p>
  
  <p>Got a macro below. It's based on an ActiveX Combo box which is linked to C3. When the user makes a selection, the macro is supposed to go find that selection on another worksheet, identify the isbn (in column 2), and return to the original worksheet to paste it in the appropriate cell (C4).</p>
  
  <p>Stepping through, it throws an "Object Required" error at isbn.Select.</p>
  
  <p>I'm sure it's something easy. Always is. Can you give me hand?</p>
  
  <pre><code>Private Sub TitleSelection_Change()
  
  Dim lookFor As Range
  Dim rng As Range
  Dim isbn As Variant
  
  Set lookFor = Sheets("AAP Dashboard").Range("C3")
  Set rng = Sheets("Books").Columns("A:I")
  
  isbn = Application.VLookup(lookFor, rng, 2)
  
  Application.ScreenUpdating = False
  
  isbn.Select
  Selection.Copy
  Sheets("AAP Dashboard").Range("C4").Select
  Selection.Copy
  ActiveSheet.Paste
  Application.CutCopyMode = False
  
  Application.ScreenUpdating = True
  
  End Sub
  </code></pre>