| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete random rows
Excel 2003
I need some code which will delete rows containing cells I have selected. Some cells may be adjacent then a space then more as below. I have tried the following, but it doesn't appear work with non-adjacent selections. Range("D4,D5,D11,D12,D13,D14,D17,D19, D23,D24").EntireRow.Delete How can this be done? donwb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select cell at random and delete contents | Excel Programming | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| In a column of text data, how do I delete random cells that have . | Excel Discussion (Misc queries) | |||
| 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 | |||
| Sort and delete for a random sample? | Excel Programming | |||
Threaded Mode
