Check out the range FormulaArray method.

--
Jim Rech
Excel MVP
"Mike Molyneaux" wrote in message
...
|I need to enter the 'ctrl-shift-enter' key sequence in a
| cell that I am writing to.
|
| Current code:
|
| sheets("name").range("aa1").value = _
| "{=sum(if(a1=nr,if(dept=70,if(acct=9," _
| & "data!$k$2:$k$2000))))}"
|
| upon execution of macro, cell aa1 contains data within
| quotes, not the sum i'm looking for.
|
| if i edit the cell & remove the { & }, then manually enter
| the 'CTRL-SHIFT-ENTER' keystroke the cell updates
| correctly?
|
| Help
|
| Thanks mike