Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Anyone with experience in these matters? I am trying to group an Excel
sheet from VBScript. No trouble doing it from a macro... Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(5, 6, 7, 8), Replace:=False, PageBreaks:=False, SummaryBelowData:=True but I can't get it to work in VBS. Specifically, this does not work, even though it should - intrinsic constant xlSum is replaced with its value... objXL.Selection.Subtotal 1, -4167, Array(5, 6, 7, 8), False, False, True Web search shows that others have had the same problem, but no solution given. References to an April, 2005 article in Windows Scripting Solutions, but I don't have that. Thanks for any assistance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
SUBTOTAL - dynamic selection | Excel Worksheet Functions | |||
Subtotal line selection | Excel Discussion (Misc queries) | |||
Trying to Sort and Subtotal with Vbscript in Excel | Excel Programming | |||
How to do selection.subtotal in VBScript/ASP ? | Excel Programming |