Use Vlookup() With VBA
<p>I keep getting an error of </p>

<blockquote>
  <p>Object Required</p>
</blockquote>

<p>running my syntax.  This is the syntax that I have, but it is not successful.  How can I write the <code>Vlookup()</code> value to my current worksheet cell T1?</p>

<pre><code>Public Sub Test()
  Dim dblInfo
  dblInfo = Application.WorksheetFunction.VLookup("A2", Sheet1.Range("A2:F171"), 4, False)
  Range("T1").Select
  ActiveCell.FormulaR1C1 = dblInfo
End Sub
</code></pre>