title: excel vba blank subtotal cells don't accept a formula
body: <p>After using Subtotals, I have some cells in the subtotals rows where I want to enter a non-subtotal formula, such as a vlookup.
  When I try to use any formula on a blank cell in Subtotal row, the formula I enter, is not calculated, as if Excel defined that any not subtotal row has to be text. Instead of giving me a result, it shows the text verbatim: =VLOOKUP(K9,PartnList!$A$3:$C$119,2,FALSE)</p>
  
  <p>Is there a way to change the "type" of a cell in a subtotal row so it accepts a formula? I want to do this via VBA repetitively, but first I want to know how to achieve it straightforward in Excel.</p>