vba Range("B8").Formula = "=COUNTIF(B2:J2,B7)"

[montecarlo2012]

Hello.
I have this formula

Range("B8").Formula = "=COUNTIF(B2:J2,B7)"

I am trying to use Cells Method like:

Cells(8, 2).formula = “=countif(“ & cells(2, 2) & “” : “” & cells(20, 2) & “, & cells(7, 2)”

but no results.

Please can you explain me why, and how to do it.
or it is not possible. I don't know,

thanks for reading.

 

[Michael M]

@montecarlo2012
To put it simply, this....Cells(2, 2).Address.....is the actual cell address, ie "B2"
And this......Cells(2, 2)....is the cell value....whatever is in the cell

 

[montecarlo2012]

Thank you Michael is a very good way to explain.