Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotaling within a Macro
Hi,
I'm writing my first macro, and I need some help. So I have my datase selected D1: the end of the data. I want to replicate the behavior o the subtotal pop up (where it asks me "Add subtotal to" and then I ca select each colum I want to see a subtotal for: Columns E1 through th last column. When I record the macro, I get this: Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(15 16, 17 _ , 18, 19, 20, 21, 22), Replace:=True, PageBreaks:=False SummaryBelowData:= _ True I think the "TotalList" Thing is messing me up. How do I select th Array from, let's say Column E through the end of the data? the numbe of columns is variable. Darn it, this is not making sense... anyone understand what i' saying? Explaining problems in excel through text is really difficult. Thanks for reading. Jo -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotaling within a Macro
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotaling within a Macro
Maybe they're at your other post!
"hosmurf <" wrote: Anyone out there? --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotaling | Excel Worksheet Functions | |||
Subtotaling | Excel Worksheet Functions | |||
Subtotaling | Excel Worksheet Functions | |||
subtotaling every third row? | Excel Worksheet Functions | |||
Subtotaling variable data in a macro | New Users to Excel |