Use SUBTOTAL(9,range) instead of SUM(range).

Hope this helps.

Pete

On Apr 21, 4:49*pm, max@SATX
wrote:
I have created a VBA function in an Excel 2003 worksheet takes a named range,
copies it, inserts it below the original range and does a re-naming of
specific text in a cell within that range. *

I am now attempting to take the sum of a column of cells within the range
and add them to the previous sum of the original cells and total them in a
different named range below all of that. *I cannot determine how to add the
two 'sub-totals' into one grand total each time a dynamically created range
is added.

Can someone please assist? *Thanks.
--
max@SATX