Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO: Delete Rows with a Macro
um, have you tied using the rows(x).delete command???
-----Original Message----- Hi, I am very familiar with VB and VB.NET and use Excel 2000. However, I don't know anything about macros. I need to write a macro that deletes rows from a spread sheet based on cell values but in a cummulative fashion. Step 1: Delete all rows if the column "% gain" is < 10 Step 2: Delete all rows remaining from the result set above if the column "xyz" 25...so on and so forth I might have 10 of these to apply like this. Can someone point me in the right direction? Thanks, Paul Reed . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to delete rows | Excel Discussion (Misc queries) | |||
Macro to delete rows if... | Excel Discussion (Misc queries) | |||
Need a macro to delete rows | Excel Discussion (Misc queries) | |||
delete rows using macro | Excel Worksheet Functions | |||
delete rows-macro | Excel Discussion (Misc queries) |