| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete random rows
The code line you posted works fine for me.
-- Rick (MVP - Excel) "donwb" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete random rows
donwb;526867 Wrote: 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 It works here, only deleting the rows of those cells, contiguous or not. Selecting non-contiguous cells and executing selection.entirerow.delete also worked as expected. (xl2003 and xl 2007) -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=144696 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete random rows
Thanks guys
I thought it should work. Now it does. Don't know what I was doing wrong. Thanks donwb "p45cal" wrote in message ... donwb;526867 Wrote: 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 It works here, only deleting the rows of those cells, contiguous or not. Selecting non-contiguous cells and executing selection.entirerow.delete also worked as expected. (xl2003 and xl 2007) -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=144696 |
| Reply |
| 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 | |||
Linear Mode
