Multiple Criteria

[efernandes67]

Hi,

I have this formula in a cell and I need someting that returns the same result in VBA.

={MATCH(1;(Name="John")*(Type="x")*(sDate>=DATEVALUE("01-01-2011"))*(eDate<=DATEVALUE("31-12-2011"));0)}

I tried the code below, but it does not work:

Please Login or Register  to view this content.

Regards,
Elio Fernandes

[efernandes67]

Hi,

I solved the problem using EVALUATE formula.

Please Login or Register  to view this content.

Elio Fernandes