![]() |
Grouping without totals
Hi!
Anybody have any macros handy to group a more than 1 columns without any totals. Using the below code: Range("A1").Select Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(20), _ Replace:=False, PageBreaks:=False, SummaryBelowData:=False will create a group based on one column and it will display sub totals. But I dont want the subtotals and also the grouping should be on two columns. -Ben |
All times are GMT +1. The time now is 05:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com