| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot Reference "Array" in Subtotal Function
Hello All,
I've just started using VB2005 Express Edition to automate Excel and hopefully make my life easier at work. I have the CurrentRegion object (selection) referenced for the subtotal but, I cannot (banging my head against the wall) figure out how reference the "Array" in the function. It's obvious to me that it's pointing to column 9. How do I get this to work? Selection.Subtotal GroupBy:=8, Function:=xlSum, TotalList:=Array(9), _ Replace:=True, PageBreaks:=False, SummaryBelowData:=True |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to replace a function with its resulting reference in a formula? | Excel Worksheet Functions | |||
| How to replace a function with its result or resulting reference in a formula? | Excel Worksheet Functions | |||
| Use INDIRECT function to reference a value in closed file | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| How do I use COUNTIF in a SUBTOTAL function to differentiate the . | Excel Worksheet Functions | |||
Linear Mode
