I need to write a macro that deletes some rows in a spreadsheet, then advances a certain number of rows, and deletes a different number of rows, advance an arbitrary number of rows, delete, etc. I have no idea how to use a variable to increment the selected cells each time.

I need to do something like:

Do this m times: {

Delete rows "r1 through r2"

Advance n1 rows

Delete delete rows "r3 through r4"

Advance n2 rows}

Next

Sorry for this clueless post...

Here are some examples that might help you

To delete second row:

Rows(2).EntireRow.Delete

To select second row:

Rows(2).EntireRow.select

To delete multiple rows - second and third

Range(cells(2,1),cells(3,1)).EntireRow.Delete

to loop through rows

For i1 = 1 To 200 Step 2
Rows(i1).EntireRow.Font.Color = vbRed
Next i1

Try it out. Hope it helps you a bit

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Here is another example that may help.

vRCnt = 1
range("A2").select
while activecell.value <> ""


wend

Here is another example that may help.

You can set your variables to increment by adding the variables using a Wend statement.
Basically a wend works the same as a loop. Refer to a vba reference guide. John Walkenback has good books.

Ex.
vSR = 1
vLR = 6
vIncR = 7
while activecell.value <> ""
do what your going to do and then increment your variables
vSR = vSR + 3 Lets say now you want your starting row variable to = 4
vLR = vLR + 6 Lets say now you want your last row variable to = 12
etc...
wend

Hope this helps some now or in the future.
Sheri