Filling An Array with a Range "Strings"

[Tirren]

How would I quickly fill an array fromt he values located in cells A1-J1, if sometimes not all of those cells are filled. I use counta to find out and redim the array to that much, but switching between the cells to upload the data escapes me. I do apologize i'm On hydracodone and having to work so my mind is fuzzy.

[shg]

Please Login or Register  to view this content.

[Tirren]

Please Login or Register  to view this content.

You're kidding right? It can't be that simple.. I ended up using a loop that did an .offset(0, n) where n was the offset updated for each iteration. Now I feel stupid.

[shg]

It's the drugs ...