J
JIM
I HAVE THE FOLLOWING IN A MACRO.
Selection.QueryTable.Refresh BackgroundQuery:=False
Selection.Subtotal GroupBy:=25, Function:=xlSum,
TotalList:=Array(26, 27, _
30, 31), Replace:=True, PageBreaks:=False,
SummaryBelowData:=True
THE SUB TOTAL TEXT EX (B H TRANSFER (POST-AUDIT) Total)
SHOWS IN COL 25.
IS THERE AN EASY WAY TO OFFSET THE SUB TOTAL TEXT TO COL
10 FOR EXAMPLE, AND LEAVE THE ACTUAL SUBTOTAL FORMULAS IN
26 AND 27
Selection.QueryTable.Refresh BackgroundQuery:=False
Selection.Subtotal GroupBy:=25, Function:=xlSum,
TotalList:=Array(26, 27, _
30, 31), Replace:=True, PageBreaks:=False,
SummaryBelowData:=True
THE SUB TOTAL TEXT EX (B H TRANSFER (POST-AUDIT) Total)
SHOWS IN COL 25.
IS THERE AN EASY WAY TO OFFSET THE SUB TOTAL TEXT TO COL
10 FOR EXAMPLE, AND LEAVE THE ACTUAL SUBTOTAL FORMULAS IN
26 AND 27