VBA Object Required When Getting Row From Range
<p>I am trying to extract a single row from a range object within a function. The range is declared as a variant, and then set to a range within my sheet. I want to be able to pick out a specific row, so I tried to call <code>.Rows(indexfrom, indexto)</code>, but I get the error <code>Object Required</code>. I've tried setting <code>compareRow</code> instead of just declaring it, but that doesn't seem to change anything. I believe it's caused because <code>callLogRange</code> only exists as a reference to the range object. If this is the case, how can I use the reference to get the row from the range? Alternatively, am I just missing something that enables you to get the row?</p>

<p>Thank you.</p>

<pre><code>Dim callLogRange As Variant
callLogRange = (Sheets("CallLog").Range("B2:L" &amp; lastRow))

Dim compareRow As Variant
compareRow = callLogRange.Rows(thisRow, thisRow)
</code></pre>