title: How to I make an absolute reference using r1c1 format in VBA for Excel?
body: <p>I am writing a macro for Excel using VBA (r1c1 format) and I want to reference a cell that is always in position E3. Is there a syntax I can use that will make an absolute reference in r1c1 format? Or is there is a way to switch to A1 and back to r1c1?</p>
  
  <p>I looked everywhere and I can't find the answer...thanks in advance.</p>