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)
 

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

Similar Threads

R1C1 Formula 2
Why are the two codes below not getting the right formula for myworksheet event change formula? 2
how to include special characters in a formula? 3
Trying to use INDEX function in VBA Code, compile error 14
Auto-calculate after a cell is filled in - Macro is looping!!! 2
Auto-calculate after a cell is filled in - macro shouldn't be loop 5
Formula in macro gives "Run-time error '1004':" 1
Insert row gives run-time error 13 message 1

Top