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