|
|
|
Author |
Message |
iceman1188
|
Posted: Tue Mar 21 15:37:46 CST 2006 |
Top |
Excel Programming >> Deleting Unique Rows
Hello, I have the following code to delete blank rows within a worksheet.
'Deletes blank lines, for advance filterring
[a1:a50000].SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Question: Is there a method to delete certain rows, if a particular cell
within a row meets certain criteria? For instance, I'd like to reference
range a1:a50000, and delete each row within this range, if "Sub Total" is the
value in any cell within column A.
Is this possible and if so, how?
Any and All Help Is Appreciated - Thank You
Excel215
|
|
|
|
|
Ron
|
Posted: Tue Mar 21 15:37:46 CST 2006 |
Top |
Excel Programming >> Deleting Unique Rows
Hi MWS
Start here
http://www.rondebruin.nl/delete.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
> Hello, I have the following code to delete blank rows within a worksheet.
>
> 'Deletes blank lines, for advance filterring
> [a1:a50000].SpecialCells(xlCellTypeBlanks).EntireRow.Delete
>
> Question: Is there a method to delete certain rows, if a particular cell
> within a row meets certain criteria? For instance, I'd like to reference
> range a1:a50000, and delete each row within this range, if "Sub Total" is the
> value in any cell within column A.
>
> Is this possible and if so, how?
>
> Any and All Help Is Appreciated - Thank You
|
|
|
|
|
|
|