| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete rows when value is within an interval in col 3
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete rows when value is within an interval in col 3
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete rows when value is within an interval in col 3
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: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete rows when value is within an interval in col 3
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: I just tested and it worked just fine. What did you do (step by step) -- Don Guillett SalesAid Software "sverre" wrote in message ... 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: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete rows when value is within an interval in col 3
Sure, just send to this address
-- Don Guillett SalesAid Software "sverre" wrote in message ... 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: I just tested and it worked just fine. What did you do (step by step) -- Don Guillett SalesAid Software "sverre" wrote in message ... 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: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Any button to insert blank rows at specific interval? | Excel Discussion (Misc queries) | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Excel macro to insert blank rows at a ever-changing interval | Excel Programming | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
Hybrid Mode
