gvreddyhr
05-05-2010, 07:26 AM
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
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