I can't answer you without further details of your "function" and what
"tasks" it performs.

Pete

On Apr 21, 9:28*pm, max@SATX
wrote:
Thanks, but this does not answer my dilemma. *I am probably not explaining it
very well. *When my function runs automatically, it creates a new task
between the first set of tasks and the grand totals. *I need the subtotal
function to automatically increase the grand total based upon the addition of
the subtotal from the new task. *The question (I think() is, how do I get
Excel to recognize the additional subtotal in the grand total column after
addition of the new task?
--
max@SATX

Here is the function in VBA:

Application.Goto Reference:="number"
Dim number As Integer
number = ActiveCell.Value + 1
ActiveCell.FormulaR1C1 = number

Application.Goto Reference:="Task1"
Selection.Copy

Application.Goto Reference:="LaborTotals"
Selection.Insert Shift:=xlDown
--
max@SATX


"Pete_UK" wrote:

I can't answer you without further details of your "function" and what
"tasks" it performs.

Pete

On Apr 21, 9:28 pm, max@SATX
wrote:
Thanks, but this does not answer my dilemma. I am probably not explaining it
very well. When my function runs automatically, it creates a new task
between the first set of tasks and the grand totals. I need the subtotal
function to automatically increase the grand total based upon the addition of
the subtotal from the new task. The question (I think() is, how do I get
Excel to recognize the additional subtotal in the grand total column after
addition of the new task?
--
max@SATX