Posted to microsoft.public.excel.programming

Costas Limassol[_2_] Costas Limassol[_2_] is offline

external usenet poster

Posts: 13

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bubble sort Error (Compile Error: Type Mismtach)	Excel Monkey[_2_]	Excel Programming	6	April 24th 09 12:16 AM
formula array gives compile error	R..VENKATARAMAN	Excel Programming	2	June 6th 06 01:20 PM
VBAProject name compile error, not defined at compile time	Matthew Dodds	Excel Programming	1	December 13th 05 07:17 PM
error message: compile error, argument not optional	Pierre via OfficeKB.com	Excel Programming	3	September 5th 05 03:45 PM

All times are GMT +1. The time now is 07:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us