title: VBA define property in a variable
body: <p>I am new to the forum, and also new to VBA (only started learning it a week ago).</p>
  
  <p>Is it possible to define a property in a variable? I have a line that looks kind of like this:</p>
  
  <pre><code>Cells(i, j).Formula = "=" &amp; .Cells(i, j).Address(External:=True, RowAbsolute:=False, ColumnAbsolute:=False)
  </code></pre>
  
  <p>I have to write several cells, so I end up having many of these lines; if possible, I would like to do something like:</p>
  
  <pre><code>dim prop as string
  
  prop = "Address(External:=True, RowAbsolute:=False, ColumnAbsolute:=False)"
  
  Cells(i, j).Formula = "=" &amp; .Cells(i, j).prop
  </code></pre>
  
  <p>Can something like this be done?</p>