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.