Posted to microsoft.public.excel.programming
|
|
Delete rows that are visible after applying filter
See
http://www.rondebruin.nl/delete.htm
Try
http://www.rondebruin.nl/delete.htm#AutoFilter
--
Regards Ron de Bruin
http://www.rondebruin.nl
"sverre" wrote in message ...
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
|