Placing concatenate in formula in cell
Posted on 2012-04-11
I am trying to place a concatenate formula into a cell. It needs to pull the number from the cell above, and add a dot and the incremental number from the For Next ( "i" in the formula. But I can'tseem to get the right combinations of parenthesis to make it work. Any help?
"i" is the increment.
A number is in the cell R[-1]C above. ie "9".
The result should be 9.1 and the next time through 9.2 etc.
ActiveCell.FormulaR1C1 = "=(CONCATENATE(R[-1]C,""."" & i & ""))"
BTW (My browser won't let me select a lower point value, so enjoy the 500 points for this question!)