VBA - remember values from a loop

[CROY1985]

Hi all

I have a loop amongst other things evaluates the following formula:

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

 

[Joe4]

You would need to store them in an array.
See here: https://www.thespreadsheetguru.com/blog/dynamically-populating-array-vba-variables