Post formula in VBA with date reference

[warp765]

Please Login or Register  to view this content.

I need the second countif criteria to be less than or equal to the d1 reference but I can't get it quite right. Any help appreciated!

[gue2013]

Please Login or Register  to view this content.

you forgot to use the "&" before d1

What is the reason why you use "external:=True, ReferenceStyle:=Application.ReferenceStyle". This makes the formula more unreadable.

cheers

[warp765]

Hi gue2013, it was advice given on my previous question about formulas in VBA. Can it be ditched then?

Cheers

[gue2013]

There are a few reasons why you could use them somewhere but not in your case.

external:=True - gives you (additionally to the worksheet name) the name of the workbook. Your formula is for your workbook and you know the name.
ReferenceStyle:=Application.ReferenceStyle --> this will be a problem if your application is set to xlR1C1 style and not to xlA1.

The best is always to test the formula directly on a sheet and then to build the string in VBA.