Add count formula in Macro

[dingdang]

Hi,


Required help to add formula in macro to count data from B2 till last row of column B as data is not fixed.

have tried to record macro but its recording cell , pls guide.


code :


Range("A100000").End(xlUp).Offset(1, 0).Select

ActiveCell.FormulaR1C1 = "39"

Range("B100000").End(xlUp).Offset(1, 0).Select

ActiveCell.FormulaR1C1 = "=COUNT(R[-28]C:R[-1]C)"

 

[SirJB7]

Hi, dingdang!


Try this:

ActiveCell.Formula = "COUNT(B2:B" & Range("B100000").End(xlUp).Row & ")"


Regards!

 

[dingdang]

Yes, Perfect!!

Thanks GURU.

 

[SirJB7]

Hi, dingdang!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!