Hi,

I am not good in programming, but the clarity of the postings from the forum is making me to understand and implement to my work environment, now I have a query regarding worksheet function (Count IF) using in Excel VBA, I kindly request to help me in solving this

Query:-

I will be updating a data in sheet1 From column "A" to Column "Y",which I will be updating daily, cells contain a text, , I want to use a count if function in column “Z” up to the last row of the data updated in column “A” , formula should return the results like :

Z1 = countif(A1:Y1,”Text”)
Z2=Countif(A2:Y2,”Text”)
.
.
.
Z100=countif(A100:Y100,”Text”)

If i drag the formula, its occupies more storage and slowdowns the application, so kindly to help me in writing VBA code the above function.

Thanks in advance

Regards
GV Reddy