C
Cresta
Hello All
I have a sheet using autofilter and subtotals.
The user has requested the list from a column filter is controlled from
checkboxes on the ribbon matching the items in the filter list. And, the
subtotal rowlevels are controlled from buttons on the ribbon too.
All works well at rowlevel 3, but rowlevel 1 or 2 the subtotal values are
zero.
I'm guessing that the coded filtering is interfering with the Excel
subtotaling but i cannot find how to get round it.
Can anyone help
Thanks
I have a sheet using autofilter and subtotals.
The user has requested the list from a column filter is controlled from
checkboxes on the ribbon matching the items in the filter list. And, the
subtotal rowlevels are controlled from buttons on the ribbon too.
All works well at rowlevel 3, but rowlevel 1 or 2 the subtotal values are
zero.
I'm guessing that the coded filtering is interfering with the Excel
subtotaling but i cannot find how to get round it.
Can anyone help
Thanks