Is there a more efficient way of populating a VBA array

Thanks for the replies.
As soon as I saw the loop I thought "why didn't I think of that" Thanks

The split function looks interesting, it's something else I'll have to learn to use
I'll leave the thread open for a little while, just in case
Cheers

Hi Norrie
I've got 40 variables that hold a number value after the first part of the code has run & I've got the array loaded & can print the contents to a worksheet. But the way I've had to load the array seems horrible. I can't load the array with the loop & Split is over my head at the mo, I'm trying to get my head round it. I'm alright with the rest of it as it's a work in progress, it's the array part I'm trying to learn
Thanks

Please Login or Register  to view this content.

Thanks Romperstomper
That made my code look amateurish lol. I had thought of Case 1 to 40, but as I hadn't tried that before I thought I'd stick to something that I know works.
The array creates it's own variable via the case loop, that makes things a lot easier to understand.
The reason I used End is when I first started to learn VBA, I had a few macros that ran right over the exit sub, but when I changed it to End, it stopped there. It was probably my even more amateurish code that was the real cause.
I've learned something
Thanks
Phil