Compile error for formula

C

Costas Limassol

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?
 
C

Chip Pearson

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)
 
S

smartin

Costas said:
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"" & ...
^
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top