Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
traversing a filtered range (excel 2007)
Hi.
Here's what I am looking to achieve. I have a list of actions like such: Name action cost VAT Alex hamburger 3.59 1.2 Alex potato chips 5.06 1.6 John hamburger 3.59 1.2 Alex payment -3.59 -1.2 I also have a cell that should display balance. Now, what I want it to do is to display a calculational result over a FILTERED range, where filter is set via standard GUI. I am assuming formulas are of no use here (please correct me if I am wrong), so what I need to know is how to most efficiently traverse a FILTERED range in VBA. Thank you for your advice. Alex. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
traversing a filtered range (excel 2007)
Also, how do I hook into the event of filter change?
thanks again. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
traversing a filtered range (excel 2007)
Take a look at the SUBTOTAL function. You can do subtotals over the entire
range you select, or just the rows or columns that are not hidden. Look in Excel help. HTH, Eric "parahumanoid" wrote: Hi. Here's what I am looking to achieve. I have a list of actions like such: Name action cost VAT Alex hamburger 3.59 1.2 Alex potato chips 5.06 1.6 John hamburger 3.59 1.2 Alex payment -3.59 -1.2 I also have a cell that should display balance. Now, what I want it to do is to display a calculational result over a FILTERED range, where filter is set via standard GUI. I am assuming formulas are of no use here (please correct me if I am wrong), so what I need to know is how to most efficiently traverse a FILTERED range in VBA. Thank you for your advice. Alex. . |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
traversing a filtered range (excel 2007)
The catch is that I don't know what lines will be filtered out. The
user determines that by setting filters' values. Plus, I am not sure if autofilter works by giving lines a hidden value or by some deeper internal means. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot delete filtered rows in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - Deleting Filtered Rows | Excel Discussion (Misc queries) | |||
copying filtered data in Excel 2007 | Excel Discussion (Misc queries) | |||
Delete Filtered Rows in Excel 2007 | Excel Discussion (Misc queries) | |||
Copying Filtered Data in Excel 2007 | Excel Worksheet Functions |