Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Rainhard Fischer   on Mar 07 In MS Office Category.

  
Question Answered By: Pravat Jainukul   on Mar 07

My code is fetching the data from oracle and dump it on excel sheet, then I'm
subtotaling on basis of the passed values

Here is the code that is getting disturbed


Selection.Subtotal GroupBy:=CInt(sGBy), Function:=xlSum, TotalList:=iSub(),
Replace:=bReplace, PageBreaks:=bPageBreak, SummaryBelowData:=bSummary

Where,
sGBy is a string (denotes Group By)
iSub() is an array.
The same code is running fine in Office 2000 SP3. Subtotal is not positioning
where it's expected to display.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Office 2003 Subtotaling Issue Or get search suggestion and latest updates.


Tagged: