mattster1010
01-12-2011, 06:25 AM
Afternoon Everyone,
I have a spreadsheet that inserts subtotals per customer account, with the subtotal being present on the value column. I use an advanced filter to show records over a certain value, for exmaple £250. These records are then filtered.
I want to use a command button to expand / collaspe all the rows filtered by the advanced filter only. I'm using the below code to expand / collapse:
Worksheets("Sheet1").Outline _
.ShowLevels rowLevels:=3, columnLevels:=1
This expands everything on the spreadsheet as oppose to just the filtered records. Anyone kindly help me out with this?
Regards,
Mattster
I have a spreadsheet that inserts subtotals per customer account, with the subtotal being present on the value column. I use an advanced filter to show records over a certain value, for exmaple £250. These records are then filtered.
I want to use a command button to expand / collaspe all the rows filtered by the advanced filter only. I'm using the below code to expand / collapse:
Worksheets("Sheet1").Outline _
.ShowLevels rowLevels:=3, columnLevels:=1
This expands everything on the spreadsheet as oppose to just the filtered records. Anyone kindly help me out with this?
Regards,
Mattster