Syntax

Hey Guys I'm a little confused on the syntax for a loop

Lets say a i have a column of in A1 A2 A3 and A4

5
7
9
10

and i want a macro to add 2 to each of the cells in b1 b2 b3 and b4
to have

7
9
11
12

Now i know this is obviously easy with fill down and formulas but how do you do it with a macro loop?

I'm just very confused on the syntax.

Thanks

There is more than one way... here's one of them:

Please Login or Register  to view this content.

Here's another:

Please Login or Register  to view this content.

Thanks alot

I'm happy to help.