Compile error for formula

  • Thread starter Thread starter Costas Limassol
  • Start date Start date
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?
 
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)
 
Back
Top