ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HOW TO: Delete Rows with a Macro (https://www.excelbanter.com/excel-programming/276708-how-delete-rows-macro.html)

Jase

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


.



All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com