title: Excel VBA: Setting a Cell Address to a variable "Object Required Error"
body: <p>I want to set a cell address to a variable. And then use that variable to set a cell formula with a referable cell <code>rng</code> i.e. Someone should be able to double click the cell with the formula and see the cell reference of <code>rng</code> rather than the value of the cell <code>rng</code> in the formula. I have the following code: </p>
  
  <pre><code>Dim rng As Range
  Dim j As integer 
  j = 5
  Set rng = ActiveSheet.Cells(j, 1).Address(False, False) ' get error here
  
  ActiveSheet.Cells(1, 15).Formula = "=5*" &amp; rng  
  </code></pre>
  
  <p>I get this "Object Required Error". What am i doing wrong?</p>