|
Subject:
|
FormulaArray problem
|
|
Posted By:
|
Golem
|
Post Date:
|
12/28/2005 2:59:08 AM
|
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
|
|
