|When you use +A1 and +B1, I assume you mean =A1 and =B1, correct?|
The plus sign is a very old school way of writing formulas and isn't seen very much any more, although it still works.
Actually, with the example you show above, you can use other means to "copy them down". This formula, placed in B100, will give you the equivalent of =A1, =B1, =C1 as you drag it down:
Since the ROW() function simply returns the number of the Row it resides in, the above formula is equivalent to this, as you drag it down:
=OFFSET($A$1,0,0) --> =A1
=OFFSET($A$1,0,1) --> =B1
=OFFSET($A$1,0,2) --> =C1
=OFFSET($A$1,0,3) --> =D1
To set up different formulas with a macro - meaning different formulas each time - you would need to know how to write VBA code, because you have to build the formula within VBA and then place it in the cells, incrementing the row and/or column for each cell. There's no "generic" formula writing code.
For example, the code for your example above would be as follows, placing =$A$1,$B$1,$C$1, etc. in B100:B109.
For rw = 100 To 109
Cells(rw, 2).FormulaR1C1 = "=R1C" & rw - 99
Perhaps if you gave us some more examples of what you are trying to do, we could be of more help.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.