Excel macro - for loop increment

Question

I've looked but can't find a solution.

How do you increment a variable? Like in any other language you just do ++(variable name) just before the end of the loop. In my example, I'd like to increment J.

Dim j as integer
j = 13
FinalRow = Range("B15").End(xlUp).Row
        For i = 9 To FinalRow
            Range("B" & i).Copy Destination:=Sheets("Design").Range("A" & j)
            J++
        Next i

The code loops from B9-B15 and pastes the information in the Designsheet from A13 and downwards.

Ben · Accepted Answer · 2011-03-15 09:33:47Z

6

Just do this:

J = J + 1

Simples.

answered Mar 15, 2011 at 9:33

Ben

35.8k6 gold badges81 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel macro - for loop increment

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related