Compile error for formula
 

I am writing the following code for a formula and I keep getting the message
that there is a compile error. Expected: list separator or ). It then
selects the colon ":"

Range("J"" & MyRow + 29).FormulaR1C1 = " =COUNTIF(R2C9:R" & MyRow &
"C9,RC[-7])"

Does anybody have any ideas?

Compile error for formula
 

You have an extra " character immediately after the J character:

Range("J"" & MyRow

should be

Range("J" & MyRow

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Thu, 10 Sep 2009 14:53:01 -0700, Costas Limassol
wrote:

Range("J"" & MyRow + 29).FormulaR1C1 = " =COUNTIF(R2C9:R" & MyRow &
"C9,RC[-7])"

Compile error for formula
 

Costas Limassol wrote:
I am writing the following code for a formula and I keep getting the message
that there is a compile error. Expected: list separator or ). It then
selects the colon ":"

Range("J"" & MyRow + 29).FormulaR1C1 = " =COUNTIF(R2C9:R" & MyRow &
"C9,RC[-7])"

Does anybody have any ideas?

Extra quote:

Range("J"" & ...
^