title: Excel VBA "self aware" formula
body: <p>Sorry if it sounds like I poorly researched this, but I'm really strugling with Googling this.</p>
  
  <p>How can I make formula that is aware of cell it is located in?<br>
  I remember that certain formulas(default ones, written by Microsoft) will use only parameters from same row as the cell this formula was written in, now I need to write one in VBA that can do the same(and more).<br>
  There was a specific name to this phenomenon if I would remember the name of it I could probally Google the rest of this problem.</p>
  
  <p>UPDATE</p>
  
  <p>Here is a simplified example of what I am trying to achieve.</p>
  
  <pre><code>Function Row() as Integer
      RowNumber = 'Some code that tells what row is this formula in
      Row = RowNumber
  End Function
  </code></pre>
  
  <p>Point being I don't want to force user to enter row number this formuila is in.</p>