| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter that yeilds no results
I'm trying to delete rows via results from a filter. The problem i'm running into is if there is no criteria that matches the filter then the header row is deleted. here's the Code i'm working with. Converttocol, lastcol and lastrow functions work fine. -
Set myrange = Range("A1:" & ConvertToCol(LastCol(ActiveSheet)) & lastrow(ActiveSheet)) myrange.AutoFilter myrange.AutoFilter Field:=12, Criteria1:="=0", _ Operator:=xlOr, Criteria2:="=2E" Range("A2:aq" & (lastrow(ActiveSheet) + 1)).SpecialCells(xlCellTypeVisible).Select Selection.Delete myrange.AutoFilter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formula yeilds non-number result | Excel Worksheet Functions | |||
| Run SQL against Access DB/Filter Results | Links and Linking in Excel | |||
| Copy Filter Results only | Excel Discussion (Misc queries) | |||
| Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
| How do I show the results of filter? | Excel Discussion (Misc queries) | |||
Threaded Mode
