Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'd like to create a code that would go through a list of values
(starting in A1 and going down), and for each value, if it equals a value specified in a list (say numbers 187 or 199), then it deletes the entire row. I realize the following script is probably more than it needs to be, can someone help? Sub Delete_Rows() For Each Row In Rows("1:65536") For Each i In MyArray(187, 199) If Cells(Row, 1).Value = i Then Rows(Row).Delete Next i Next Row End Sub Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |