title: VBA point variable to range
body: <p>I want to point to a cell as a range in VBA. I've tried using:</p>
  
  <pre><code>         Dim range
           range = Sheet("sheet").Range("A1")
  </code></pre>
  
  <p>But this just returns the value in the range. What I actually want is the range object so I can manipulate it, e.g. by setting range.Value = "Hello"</p>
  
  <p>Any ideas?</p>