Writing a Formula using R1C1 code in VBA code

Dear Forum,

I am writing a macro where I need to write a Formula in a specific column C based on the contents and the row size of the Column B..

Ex: The formula starts from the StartRow = 2 in the Column C and the LastRow of the Column A...
Its a simple Countif Formula to be auto inputted each time the Macro is run..

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can someone help me with the code in the column C based on the COlumn which is also a formula converted to a value...

Warm Regards
e4excel

Thanks a lot, Izandol...
It worked like a charm, please explain how to make the columns absolute as well as the rows...

I am not able to make out which line does the trick , i would prefer to make the columns absolute..

Regards
e4xcel

Thanks again but does the number 2 or [-1] have anything to do with making the Absolutes?

Then what makes the COlumns And the Rows Absolute

No my question was not just that but how do i make it locked , the way we do using "$" in regular formulas...if I need to use the [-1] as well as "$"