Calculating subtotals
Hi Don,
This is in response to a comment made by Ron Rosenfield under my "Need
subtotals" posting.
I guess I was under the false impression that Google Groups could be
used to solicit help from "experts".
Since Excel Subtotals command wasn't doing what I needed to do very
quickly and I'm not familiar with Pivot Tables, my OP asked for
assistance and Don graciously provided the macro. He later suggested
that I "Just add a line" but he provided three lines:
'MsgBox br
Cells(br + 1, 1) = " Keys Total" ' add this line
With Range("b" & br + 1 & ":f" & br + 1)
Since I'm not at all familiar with macros, I didn't know where, in
Don's original macro, to add the line(s).
Gary
|