Hi all, been a while but I'm back at it but little fuzzy on this one. How do I take the UBound() elements from an existing array, and use it to populate a brand new array? For example, let's say the existing array has UBound(10000). A new string array, let's call it NewArrayLineCounter() is created. NewArrayLineCounter() would need to be created, and then I assume using a For...Next loop to populate each new array element with a line number reference. So example array contents might include NewArrayLineCounter(1) = "Line000001", NewArrayLineCounter(2) = "Line000002", etc. through 100000 in this case (note in advance I can't use a multidimensioned array or that would have been preferred). Thanks for any advice, I hope it's something simple I'm overlooking...