title: Returning a range from an Offset from another range VBA
body: <p>How can I return a range from an function which includes an offset from another range?</p>
  
  <p>This is my code (Function):</p>
  
  <pre><code>Private Function ProcessRange(rng) As Range
      If rng &lt;&gt; "A1" Then
          ProcessRange = Range(rng).Offset(r + 2)  //this is the problem
      Else
          ProcessRange = Range("A1")
      End If
  End Function
  </code></pre>
  
  <p>From the example above, I'm trying to replace the range from the offset function. Is it possible?</p>