Posted to microsoft.public.excel.programming

Chet

external usenet poster

Posts: 88

Expected expression error help

Can anyone figure out why this line of code creates the compile error
message "expected expression"? I am trying to put a formula array
into a cell.

Selection.FormulaArray = _
"=SUM(IF('Raw data'!R4C6:R" & MaxRowSource & "C6=RC2,IF('Raw data'!
R4C" & SourceDOWCol & ":R" & MaxRowSource & "C" & SourceDOWCol &
=""x"", _
"IF('Raw data'!R4C17:R" & MaxRowSource & "C17<R3C,IF('Raw data'!
R4C18:R" & MaxRowSource & "C18R3C,'Raw data'!R4C16:R" & MaxRowSource
& "C16)))))"

Thanks,
Chet

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
VBA Expected end of statement ERROR	Paul Lambson	Excel Programming	3	November 18th 08 09:58 PM
Expected end of statement error	Patrick C. Simonds	Excel Programming	1	August 14th 08 08:28 PM
concatenate expression error	philr	Excel Worksheet Functions	2	July 26th 07 04:18 PM
compile error: Expected: = ...Why?	cesw[_2_]	Excel Programming	3	September 10th 05 12:41 AM
Expected:expression	Capinvest	Excel Programming	3	August 4th 03 02:36 PM

All times are GMT +1. The time now is 02:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us