| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows that are visible after applying filter
Hi
I have the following code: Selection.AutoFilter Field:=4, Criteria1:="=*ÖVROBL*", Operator:=xlAnd Now I would like to delete rows that are visible except the first which contains the headlines. How do I write that? Br Sverre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete only visible rows in filter mode | Excel Discussion (Misc queries) | |||
| Help with filter Range & delete rows | Excel Programming | |||
| No. of rows selected from auto filter not visible on toolbar? | Excel Discussion (Misc queries) | |||
| Applying Formulas to Visible Cells Only | Excel Discussion (Misc queries) | |||
| Applying auto-filter with large number of rows | Excel Discussion (Misc queries) | |||
Threaded Mode
