delete rows when value is within an interval in col 3

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

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

<11000000

How do I write that syntax?

Best regards
Sverre
 
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
 
Hi Don

It works only for one line at a time - it does not check all lines. It stops
and you need to repeat the macro.

Any ideas?

Br

"Don Guillett" skrev:
 
I just tested and it worked just fine. What did you do (step by step)
 
Hi Don

Can I send you a mail with the doc as attach. and you can see what happens?

I think something is wrong with the row count.

Sverre

"Don Guillett" skrev:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
delete rows with multiple criteria 2
Search Target <= in Col. "B" to return Date in Col. "A" 1
delete rows that have a duplicate id keeping the upper row 6
Compare data set 1 with data set 2. Add to data set 2 if not found 0
UserForm Delete Sheet Columns 2
Macro deleting rows based in main sheet on values in another sheet 5

Back
Top