Hi all
I have a loop amongst other things evaluates the following formula:
Obviously when it loops back onto the next "i" then prodcount resets, How can i adapt it so where "i" is 1 i would want to store the result as prodcount1, where "i" is 2 store the result as prodcount2? etc.
Thanks
I have a loop amongst other things evaluates the following formula:
Code:
prodcount = WorksheetFunction.CountIf(Range("CATGRPS"), Range("Cat_List_Unique").Cells(i + 1, 1))
Obviously when it loops back onto the next "i" then prodcount resets, How can i adapt it so where "i" is 1 i would want to store the result as prodcount1, where "i" is 2 store the result as prodcount2? etc.
Thanks