repeat number 5 times and increment

Hi this code increments an alphanumeric number by 1 in the column range. But I want the number to repeat 5 times before incrementing.
eg. 111112222233333444445555566666
How would i do this?
Thanks

Please Login or Register  to view this content.

tyr

Please Login or Register  to view this content.

Yes, that's right thanks.
You just need to declare the new variable.