| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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])" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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"" & ... ^ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bubble sort Error (Compile Error: Type Mismtach) | Excel Programming | |||
| formula array gives compile error | Excel Programming | |||
| VBAProject name compile error, not defined at compile time | Excel Programming | |||
| error message: compile error, argument not optional | Excel Programming | |||
![Costas Limassol[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
