Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why won't this or any other way I have tried to write this line work?
Set x = rng.Subtotal(groupby:=1, Function:=xlSum) Argument not optional error Dim x as long With Range(rn) 'tells range to use rc = .Find(DateValue(dt), LookIn:=xlValues, _lookat:=xlWhole).Rows.Row 'get row number of match rng = ("b" & rc & ":" & "l" & rc) 'sets range to subtotal Set x = rng.Subtotal(groupby:=1, Function:=xlSum) End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Sort, Subtotal, Label Subtotal, Insert row | Excel Programming |