VBA Formula into Cell: Countif: Why doesn't this work???

I am going nuts on this and it has to be something stupid.:

Please Login or Register  to view this content.

If I break it back to using COUNTA instead

Please Login or Register  to view this content.

and trim off the

Please Login or Register  to view this content.

it operates just as a COUNTA should, so I can not understand it! (I have verified that the variables when changed over to the COUNTIF example do have valid information).

sSup = string name of a tab
sIRcol = string name of a columne, such as "I"
sAddress = string of an address, such as "I36"

What have I done???

Many thanks, frustration has gotten the better of me so I am probably not thinking straight...

You are missing few speech marks on strings ""Yes""

It must have been the frustration.

I thought I tried every combination physically possible.

I even tried combinations I swore were idiotic to try.

Thank-you so much. You folks are GREAT.
Live and learn...