View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BenJose BenJose is offline
external usenet poster
 
Posts: 1
Default 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