Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeated application of AutoFilter
Hi,
I am attempting to apply an autofilter in a loop (to compute subtotals). I have a single cell selected Set ws = WorkSheet(1) ws.Range("A1").Select Selection.AutoFilter Field:=1, Criteria1:=FieldVal FieldVal changes with every iteration of the loop. I am attempting to get the special cells with Set FilterData = ws.Range("A1") MsgBox( FilterData.CurrentRegion.SpecialCells _ (xlVisible).Areas.Count) The last statement gives me a value of 1 sometimes for the second iteration and higher of my loop. Unsure what I am doing wrong here. Any help is much appreicated. thanks, -shishir |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeated application of AutoFilter
If you have any hidden rows (which one would expect you would) then the
number of areas should be 1. I assume you are setting the filter to show only one record. However, since you are starting in row 1 and it is being treated as a header row (whether it is or not - but it should be a header row), then row1 is always visible and the matching record is visible -- unless that is row 2, then you will get areas 1. -- Regards, Tom Ogilvy sramam wrote in message ... Hi, I am attempting to apply an autofilter in a loop (to compute subtotals). I have a single cell selected Set ws = WorkSheet(1) ws.Range("A1").Select Selection.AutoFilter Field:=1, Criteria1:=FieldVal FieldVal changes with every iteration of the loop. I am attempting to get the special cells with Set FilterData = ws.Range("A1") MsgBox( FilterData.CurrentRegion.SpecialCells _ (xlVisible).Areas.Count) The last statement gives me a value of 1 sometimes for the second iteration and higher of my loop. Unsure what I am doing wrong here. Any help is much appreicated. thanks, -shishir |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
Selective Autofilter Application | Excel Discussion (Misc queries) | |||
Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) |