I am trying to build a sumif equation to be placed into a cell using vba. I
have declared and set "ColRng " and "RngRef" to ranges. when I try to get
out of this equation I keep getting notified that the comma is causing
problems.

Any insight appreciated

xlApp.Range("j28") = "=sumif(('CPCT DEC'!" & ColRng & ")" &,& 89298,"('CPCT
DEC'!" & RngRef&"))"