converting excel formula in vba code

[Patriot2879]

Hi, Please can you help me i would like to convert the below excel formula into vba code, can you help me please? thank you for your time.

=COUNTIFS(CMEXPORTINPUT!B:B,"Buckinghamshire",CMEXPORTINPUT!H:H,"Pending")

 

[nemmi69]

Actually this seems to work better

CI = [COUNTIFS(CMEXPORTINPUT!B:B,"Buckinghamshire",CMEXPORTINPUT!H:H,"Pending")]


Worksheets("CMEXPORTINPUT").Range("J10").Value = CI

The []'s are a short code for Evaluate

PS I noticed that the answer on the spreadsheet in the original formula is 1 to many.

 

[Patriot2879]

thank you for your help much appreciated