title: Editing this question again. I think .formula should be working for my range object. Do excel tables work differently on formulas?
body: <p>I have used
  Here is the code I have</p>
  <pre><code>With wb.Worksheets(w)
         arr = .Range(.Cells(6, &quot;C&quot;), .Cells(.Rows.Count, &quot;D&quot;).End(xlUp)).Formula
      Debug.Print arr(1, 1) ' 
      Debug.Print arr(1, 2) '   
  </code></pre>
  <p>Here is the result
  iSharesNASDAQ100 Idx ETF (C-H) (XTSE:XQQ)
  =[@Shares]<em>[@[Current Price]]
  the second column d  has the formula =[@Shares]</em>[@[Current Price]]
  From what I have read .formula should be working on both of the columns.</p>
  <p>Thank you for any help.</p>