Try adding:
to the end of the code.![]()
Range("D:T").Replace "SUBTOTAL(9,", "SUM("
Try adding:
to the end of the code.![]()
Range("D:T").Replace "SUBTOTAL(9,", "SUM("
Everyone who confuses correlation and causation ends up dead.
Hi Romperstomper.. Please see post below with attachment..
Last edited by tek9step; 09-30-2010 at 06:29 AM.
I tried it didnt work.. it did change the subtotals to sum but no change on cumulative totals..
Last edited by tek9step; 09-30-2010 at 06:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks