View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chet Chet is offline
external usenet poster
 
Posts: 88
Default 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