Hi Folks

Have been trying to create my first attempt at a macro, and need some basic help regarding 2 items

Ques
I want to create a results based on a range of data. ie If countif a1 / count (G1:G5), where the results displayed would be say 2 / 5. I've managed to code it but don't understand how to convert the RC values to A1:B1 type values. Here is code which work versus my guess.

ActiveCell.FormulaR1C1 = "=CONCATENATE(COUNTIF(Sheet1!RC[5]:R[7]C[5],""<1""),"" /"",COUNT(Sheet1!RC[5]:R[7]C[5]))

ActiveCell.FormulaR1C1 = "=CONCATENATE(COUNTIF(range(Sheet1!G2:G6)),""<1"") ,"" /"",COUNT(range(Sheet1!G2:G6)))

Can someone explain how I can convert the RC to A:B type.

Ques 2
I want to do a similar thing but have a criteria which is countif A between 1 and 1.3 (1<1.3) / count(G2:G5)

thanks in advance....