View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sverre sverre is offline
external usenet poster
 
Posts: 78
Default 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