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