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