lr=cells(rows.count,"c").end(xlup).row
for i=2 to lr
if cells(i,"c")999 and cells(i,"c")<1100 then rows(i).delete
next

--
Don Guillett
SalesAid Software

"sverre" wrote in message
...
Hi

I would like to delete rows in col 3 IF the value in col 3 is in the
interval below:

9999999

<11000000

How do I write that syntax?

Best regards
Sverre