Insert formulas in VBA code

[saurabhlotankar]

Hi All,

First of all thank so much everyone for assisting me learing VBA coding. I have started doing it on my own as a beginner.
I am creating a file in which i am done with half of my work but am stuck at one point where i need to enter countif formula in VBA code.

I have attached my working file here.

• First i want to add a column ahead of column"C"(It will be "D") and Give header to it as "Active/Inactive"
• From D2 onwards till the end(in this example its D10) i want to put countif formula to count number of "True" in each row. So in D2 the formula will be=countif(E2:M2,"True") and so on till the end
• In the same way i want to add one more column in the beginning that will become column "M". and from A2 onwards i want to put formula =C2&B2

I want a VBA code for these two steps. If you could help with in it then that will be really helpful.

Thanks