deleting mutliple rows in different ranges at same time

[Guest]

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.

 

[Bob Phillips]

Work bottom-up instead of top-down.

--

HTH

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

 

[Guest]

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]

--

HTH

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

 

[Bob Phillips]

Yes

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

--

HTH

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