deleting mutliple rows in different ranges at same time

Work bottom-up instead of top-down.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"HeatherO" <HeatherO@discussions.microsoft.com> wrote in message
news:830BE7B3-E764-4F1F-B300-1735D61F7005@microsoft.com...
> I was just wondering if there is anyway to delete multiple rows in
different
> ranges at the same time? I have a spreadsheet and I was doing the
deletion
> at the same time as I was populating one of the columns and when I do the
> deletion it deletes the row but then all the rows below it move up one and
I
> am deleting things I don't want to. All I would like to do is highlight
with
> in rows 10-25 certain ones that contain 0 values in column C and delete
them
> and at the same time rows 38-46 that have 0 values in column C delete
them.
> If I delete the first range then my original rows which were 38 - 46
become
> different rows and therefore I am looking at the wrong data. Any help or
> suggestions I would appreciate, I don't know if you can do this or not but
it
> would be great if you could.

I was thinking of that as I was writing this. Can I do a for counter = 25 to
10?? I think my coffee just has not sunk in yet. I know there is a way.
Thanks for your help.

"Bob Phillips" wrote:

> Work bottom-up instead of top-down.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "HeatherO" <HeatherO@discussions.microsoft.com> wrote in message
> news:830BE7B3-E764-4F1F-B300-1735D61F7005@microsoft.com...
> > I was just wondering if there is anyway to delete multiple rows in
> different
> > ranges at the same time? I have a spreadsheet and I was doing the
> deletion
> > at the same time as I was populating one of the columns and when I do the
> > deletion it deletes the row but then all the rows below it move up one and
> I
> > am deleting things I don't want to. All I would like to do is highlight
> with
> > in rows 10-25 certain ones that contain 0 values in column C and delete
> them
> > and at the same time rows 38-46 that have 0 values in column C delete
> them.
> > If I delete the first range then my original rows which were 38 - 46
> become
> > different rows and therefore I am looking at the wrong data. Any help or
> > suggestions I would appreciate, I don't know if you can do this or not but
> it
> > would be great if you could.
>
>
>

--

HTH

RP
(remove nothere from the email address if mailing direct)


"HeatherO" <HeatherO@discussions.microsoft.com> wrote in message
news:3502C6EA-AED4-4EFA-BD49-760BF51C8149@microsoft.com...
> I was thinking of that as I was writing this. Can I do a for counter = 25
to
> 10?? I think my coffee just has not sunk in yet. I know there is a way.
> Thanks for your help.
>
> "Bob Phillips" wrote:
>
> > Work bottom-up instead of top-down.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "HeatherO" <HeatherO@discussions.microsoft.com> wrote in message
> > news:830BE7B3-E764-4F1F-B300-1735D61F7005@microsoft.com...
> > > I was just wondering if there is anyway to delete multiple rows in
> > different
> > > ranges at the same time? I have a spreadsheet and I was doing the
> > deletion
> > > at the same time as I was populating one of the columns and when I do
the
> > > deletion it deletes the row but then all the rows below it move up one
and
> > I
> > > am deleting things I don't want to. All I would like to do is
highlight
> > with
> > > in rows 10-25 certain ones that contain 0 values in column C and
delete
> > them
> > > and at the same time rows 38-46 that have 0 values in column C delete
> > them.
> > > If I delete the first range then my original rows which were 38 - 46
> > become
> > > different rows and therefore I am looking at the wrong data. Any help
or
> > > suggestions I would appreciate, I don't know if you can do this or not
but
> > it
> > > would be great if you could.
> >
> >
> >

Yes

For cntr = 25 To 10 Step -1
...
Next cntr

--

HTH

RP
(remove nothere from the email address if mailing direct)


"HeatherO" <HeatherO@discussions.microsoft.com> wrote in message
news:3502C6EA-AED4-4EFA-BD49-760BF51C8149@microsoft.com...
> I was thinking of that as I was writing this. Can I do a for counter = 25
to
> 10?? I think my coffee just has not sunk in yet. I know there is a way.
> Thanks for your help.
>
> "Bob Phillips" wrote:
>
> > Work bottom-up instead of top-down.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "HeatherO" <HeatherO@discussions.microsoft.com> wrote in message
> > news:830BE7B3-E764-4F1F-B300-1735D61F7005@microsoft.com...
> > > I was just wondering if there is anyway to delete multiple rows in
> > different
> > > ranges at the same time? I have a spreadsheet and I was doing the
> > deletion
> > > at the same time as I was populating one of the columns and when I do
the
> > > deletion it deletes the row but then all the rows below it move up one
and
> > I
> > > am deleting things I don't want to. All I would like to do is
highlight
> > with
> > > in rows 10-25 certain ones that contain 0 values in column C and
delete
> > them
> > > and at the same time rows 38-46 that have 0 values in column C delete
> > them.
> > > If I delete the first range then my original rows which were 38 - 46
> > become
> > > different rows and therefore I am looking at the wrong data. Any help
or
> > > suggestions I would appreciate, I don't know if you can do this or not
but
> > it
> > > would be great if you could.
> >
> >
> >