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.