I feel like I have been coding for too long this afternoon, because for the life of me, I can't find a solution to what seems to be a simple problem.

I have an array that I need to extend multiple times over.

Dim dz() as Double
Redim dz(1 to 10)

I have the variable dz() full of 10 random numbers. I need to copy that number sequence (1 through 10) 10 times into another array.

Python does this quite easily, but I'm struggling to figure it out in VBA. Any thoughts on how you can do this?