| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
No match on Advanced Filter -- how to detect?
I have a user form that allows the user to filter data. If they filter
the data, I colour a few cells red so that they have a visual cue that some rows are hidden. However, if their criteria don't match any data in the database, then no rows are hidden even though I have applied an advanced filter. If this is the case, I don't want the cells coloured red. I can count visible rows before the advanced filter and compare to visible rows after the advanced filter, but I was wondering if there might be a simpler way? Activesheet.FilterMode = True after the advanced filter even if there are no hidden rows, so that's out. Any suggestions? -- Dianne |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
No match on Advanced Filter -- how to detect?
Sigh. Never mind --
lngNumRowsVisible = Range("A:A").SpecialCells(xlCellTypeVisible).Count If lngNumRowsVisible < 65536 Then code End if -- Dianne In , Dianne typed: I have a user form that allows the user to filter data. If they filter the data, I colour a few cells red so that they have a visual cue that some rows are hidden. However, if their criteria don't match any data in the database, then no rows are hidden even though I have applied an advanced filter. If this is the case, I don't want the cells coloured red. I can count visible rows before the advanced filter and compare to visible rows after the advanced filter, but I was wondering if there might be a simpler way? Activesheet.FilterMode = True after the advanced filter even if there are no hidden rows, so that's out. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced filter data match | Excel Discussion (Misc queries) | |||
| Use Advanced Filter to Detect non blank rows | Excel Discussion (Misc queries) | |||
| advanced filter - can't match a long text cell | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Linear Mode
