I've been trying to create a macro to count the occurrence of a character in a range. the macro should search through every column for the string.
For column = 2 To 6

    Cells(15, column ).Select
    Selection.FormulaArray = _
        "=SUM(LEN(R[-13]C[column]:R[-7]C[column ])-LEN(SUBSTITUTE(R[-13]C[column ]:R[-7]C[column ],""A"","""")))"
Next column

however, i keep getting the following error message:"unable to set the formulaarray property of the range class" it seems to have something to do with my using of a variable in the R[]C[]
thanks