title: Relative Cell Address needed in Excel VBA
body: <p>I need a <strong>relative</strong> cell address. i.e. "A2" not "$A$2"</p>
  
  <p>When I use <code>myAddress = Worksheets("Sheet1").Cells(1, 2).Address</code>,
  myAddress returns $B$2. I actually need the relative value <code>B2</code>.</p>
  
  <p>Why, you ask? I knew you would ask... Because I want to then fill down the formula using that <code>B2</code> cell address to all of the cells below it. And I don't want each subsequent cell to refer to <code>B2</code>, but <code>C2</code> then <code>D2</code> and so on.</p>