Create a variable with a dynamic name

I have an IF statement contained within a WHILE loop which runs down a column. At every passing I want a new String variable created with the row number as part of the name. Thus on the first pass a string variable would be created called String1, on the second there would be a String2 variable created, and so on.
What I'm really trying to do here is create a message box with a message generated each time the loop is performed. This is me trying to work around the length limit imposed on the String variable. Another solution to this is also welcome, this is just the solution I had in my head.

Hi

I suggest that you look at using a collection.

Please Login or Register  to view this content.

gives you access to MyVariable(1) to MyVariable(Massive)

http://www.functionx.com/vbaexcel/objects/Lesson6.htm

Thanks, the Array suggestion worked. Now I'm just to get the message box to display every instance of the array :P