Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code returns only one row of data after the header.
However range: rngColumnsToPopulate seems to only see the header row not the row beneath it. Anyone know what might be wrong. It's the same code I've used in the past when only one field has been used for filtering criteria. Now I'm using 3 fields the code only seems to see the header row. With ws .UsedRange.AutoFilter field:=colSource, Criteria1:="AED", VisibleDropDown:=False .UsedRange.AutoFilter field:=colMemo, Criteria1:="=", VisibleDropDown:=False .UsedRange.AutoFilter field:=colActionType, Criteria1:="=", VisibleDropDown:=False Set rngColumnsToPopulate = .UsedRange.SpecialCells(xlCellTypeVisible, True) End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 200 Pivot Field Selections Are Locked | Excel Discussion (Misc queries) | |||
PT - list multiple page field selections | Excel Programming | |||
Apply autofilter selections to 2nd table automatically? Macro? | Excel Worksheet Functions | |||
Improve visibility of Excel AutoFilter Filter selections | Excel Worksheet Functions | |||
How do I get "multiple selections" displayed in Pivot Table Field | Setting up and Configuration of Excel |