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

The code line you posted works fine for me.

--
Rick (MVP - Excel)


"donwb" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>

Thanks guys
I thought it should work.
Now it does.
Don't know what I was doing wrong.
Thanks
donwb



"p45cal" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
>
> 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
>