| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Autofilter -- what if criteria doesn't exist? Error handling??? Please help...
Hi, I'm asking excel to update an autofilter with the following line:
Selection.AutoFilter Field:=61, Criteria1:="2" However, I just noticed that 2 is not always in the list. In that case, it doesn't auto filter anything and all rows are still visible. Is there a way that I can get it to display zero rows if it can't autofilter by the desired criteria? Thanks, Rob (bertbarndoor) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent getting all rows if Autofilter criteria doesn't exist | Excel Programming | |||
| Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| 3 criteria must exist in adjoining cells then rtn val from 4th | Excel Discussion (Misc queries) | |||
| Error handling with a handling routine | Excel Programming | |||
Threaded Mode
