title: Refering to excel cells in absolute and relative terms
body: <p>Let's say I have a given range as argument to a function:</p>
  
  <pre><code>Function wrapper(current As range)
  </code></pre>
  
  <p>now I would like to get the value of the cell that to the <em>far</em> left (Column <code>A</code>).</p>
  
  <p>E.g if current cell is <code>H12</code>, I would like to get cell text which is in <code>A12</code>.</p>
  
  <p>Thank you for your help</p>
  
  <hr>
  
  <p>ok, lets leave out above problem. In general, what I want to achieve is to get a variable of Range type. In below example:</p>
  
  <pre><code>Function wrapper(current As range)
  Set hardwarePos = Cells(current.Row, 1)
  </code></pre>
  
  <p>my hardwarePos is of type Set, and I can not pass it to another function ( GetFormula(var as Range). :</p>
  
  <pre><code>Function wrapper(current As range)
  Set hardwarePos = Cells(current.Row, 1)
  wrapper = GetFormula(hardwarePos)
  </code></pre>
  
  <p>This is not working...</p>
  
  <hr>
  
  <p>thank's for you tips. I like the way KazJaw solved it, but stil I have some problems. Why this does not work:</p>
  
  <pre><code>Function wrapper(current As range)
  Dim hardwarePos As range
  hardwarePos = Cells(current.Row, 1)
  wrapper = hardwarePos.Text
  End Function
  </code></pre>