Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings! Have run into an apparent glitch, would appreciate any ideas.
Briefly: 1. Selection.AutoFilter Field:=2, Criteria1:="Test" ' isolate rows of interest using an autofilter 2. Range("B1").Offset(1).Select ' select first data cell below header cell 3. Range(Selection, Selection.End(xlDown)).SpecialCells(xlCellTypeVisi ble).Select ' select filtered cells 4. Set Config = Selection ' assign handle to the range collection Up to here, everything is okay, sort of. If there is at least one visible row in the filtered list, then Config.count accurately reflects the number of autofiltered rows (cells, actually), and Config can be used as a collection for subsequent processing. HOWEVER, if there are no filtered cells (meaning no data row is visible in the autofilter), then Config.count is not zero but rather is some large number (less than total number of rows in data set). Q1: What is it doing? Is this somehow self-inflicted? Q2: As a work-around, what are options to identify what should be an empty collection? Office 2003 with all updates. Thanks! George |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB Question - AutoFilter related - 'Criteria1:' secion of my code | Excel Programming | |||
How are these uses of SpecialCells different? | Excel Programming | |||
SpecialCells | Excel Programming | |||
Specialcells | Charts and Charting in Excel | |||
AutoFilter /specialcells | Excel Programming |