I am trying to make this comparison work;
xlApp.Range("j15") =
xlApp.WorksheetFunction.SumProduct(--(xlApp.Worksheets(ShtRef).Range(ColRng)
= "89298"), --(xlApp.Worksheets(ShtRef).Range(rngref) 0))
'xlApp.WorksheetFunction.CountIf(xlApp.Worksheets( ShtRef).Range(ColRng),
"89298") + xlApp.WorksheetFunction.CountIf(xlApp.Worksheets(" Dec
Contract").Range(ColRng), "89298")

Variables for range and sheet names are correct and work in many other
situations so I know its not them.

I want to set a field equal to the number of times both criteria match. If I
plug it into the cell manually with out the Worksheets. etc syntax and use
the Range:Range notation it works on the range.

Any Ideas on what I'm doing wrong