Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

adding lines to subtotal groups

Status
Not open for further replies.

daveonion

Programmer
Aug 21, 2002
359
GB
hi i'm using the subtotal function, i.e.
Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=adders, PageBreaks:=True

and i'm wondering whether there is a piece of code which would add a line to seperate data from the subtotal for every group.
any help would be appreciated thanks

ps the size of the report will be different everytime the code is ran
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top