Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access table results after filtering
really.. this isn't home work.
Dim oWs As Worksheet: Set oWs = ActiveSheet Dim oRg_columns As Range: Set oRg_columns = oWs.Columns("D:E") oRg_columns.AdvancedFilter Action:=xlFilterInPlace, Unique:=True Dim oLO_table As ListObject: Set oLO_table = oWs.ListObjects(TABLE_METRIC) So far so good. The filtering worked. I can see the display update. How do I iterate, row by row, thru only the results? I just ask a general question because I've tried 20 different constructs. If this is just a few lines, could I get some help? I will go to amazon now. I want to collect a few columns from each showing row. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
access table results after filtering
GOT IT!
Dim oRg_columns As Range Dim oLO_table As ListObject DIM rgT as Range Set oRg_columns = oWs.Columns("D:E") oRg_columns.AdvancedFilter Action:=xlFilterInPlace, Unique:=True Set oLO_table = oWs.ListObjects(TABLE_ACTUALS) For Each rtT In oLO_table.Range.SpecialCells(xlCellTypeVisible).Ro ws MsgBox "row " & rt.row & ", " & rtT.cells(rtT.row, 3) Next |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FILTERING RESULTS | Excel Worksheet Functions | |||
Filter pivot table results without filtering in SQL query | Excel Programming | |||
VBA - query an Access table - results in Excel | Excel Programming | |||
Filtering results | Excel Programming | |||
Filtering results | Excel Programming |