MOVE SUBTOTAL TEXT

[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