Does this data exist on a worksheet?

Could the numbers be generated as the array is generated?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"hotherps " wrote in message
...
I have a for next loop that assigns a string value, there are 3 strings
in the array. There is also one 3 digit number per string.
Iwant to be able to list all of the strings but never repeat it's 3
digit number. All three strings should be available for use at any time
but if the 3 digit number exists in the next column to be filled, it
should increment to the next highest value.

I hope I'm explaining this right, I'm really struggling with it.

Thanks


---
Message posted from http://www.ExcelForum.com/