CountIf with variable Range

[fadib]

Hi guys,
I am trying to write a code that can count the number of letter "u" between two cells.
a = 32
b = 40
C = 35

[VBA]Cells(C, "Z") = "=COUNTIF(Range(Cells(35,a),Cells(35,b)),""u"")"[/VBA]

Not working !! what I am doing wrong?

[Bob Phillips]

Is this what you mean

Cells(C, "Z") = Application.CountIf(Range(Cells(a, "A"), Cells(b, "A")), "u")

[fadib]

Thanks Xld,
so the trick was to use application.
Just curious, why recording a macro doesn't use "Application."?

[Bob Phillips]

Because recording puts the formula into the formula property, you were trying to stuff it into value, but even then not using the correct values.