title: VBA defining Range with Cells() Error 1004
body: <p>I am searching for a value and getting its Row with this, and I want to make a Range Variable with lRow and 2 (because it will always be 2), but it doesn't seem to work...</p>
  
  <pre><code>Dim lCol As Long
  
      lRow = ThisWorkbook.Sheets("Data").Cells.Find(What:="*", _
                      After:=Range("A1"), _
                      LookAt:=xlPart, _
                      LookIn:=xlFormulas, _
                      SearchOrder:=xlByRows, _
                      SearchDirection:=xlPrevious, _
                      MatchCase:=False).Row
  
  lRow = lRow + 1
  Dim newentry As Range
     Set newentry = Range(Cells(lRow, 2))
  </code></pre>
  
  <p>Here, <code>lRow = 3</code> is given as value...</p>
  
  <p>Runtime error 1004: Method "Range" for object '_Global' failed</p>