PDA

View Full Version : Command Button To Expand / Collaspe Subtotals



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

IBihy
02-24-2011, 09:43 AM
Hello,

without diving too deeply yet, I think you should attach a WB as sample. Would make it easier to catch on to, methinks.

Regards,
Isabella