MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Multilevel subtotals are in the wrong position

  Asked By: Jimmy    Date: Feb 11    Category: MS Office    Views: 1801

Every one, I've posted so many solution. But Now i'm looking for a

While doing multilevel subtotaling GRAND TOTAL appear in wrong
position in
Excel 2000.

I'm trying to subtotal using VBA code. While subtotaling on 1st level
it's giving me the ryt result. While subtotaling on 2nd level the 2nd
level subtotal shifted above the Grand total, similarity is the case
for 3level and 4level.

I've referred the Microsoft Hot Fix
(support.microsoft.com/default.aspx) for
the said problem but still getting the same error in subtotal.



3 Answers Found

Answer #1    Answered By: Jackson Williams     Answered On: Feb 11

You'll need to post your code..............

Answer #2    Answered By: Ethan Evans     Answered On: Feb 11

Here is the code:

Selection.Subtotal GroupBy:=CInt(atGby), Function:=xlSum,
TotalList:=Array(aiSub(1), _
aiSub(2), aiSub(3), aiSub(4), aiSub(5), aiSub(6), aiSub(7), aiSub(8),
aiSub(9), aiSub(10), _
aiSub(11), aiSub(12), aiSub(13), aiSub(14)), Replace:=abReplace,
PageBreaks:=abPageBreak, SummaryBelowData:=abSummary

Where aiSub() is an Array interger type, and atGby for group by like for 1st
level 1, 2nd Level 2 and so on.

Recently I've discovred if i pass TotalList:= Array(17,18,19,....) it works
perfectly but using aiSub() array element, giving me wrong  position.

Answer #3    Answered By: Komal Mohammad     Answered On: Feb 11

The microsoft article entitled
"Multilevel subtotals are in the
wrong position  in Excel 2002 and
in Excel 2003" at
might be what you need.

Didn't find what you were looking for? Find more on Multilevel subtotals are in the wrong position Or get search suggestion and latest updates.