Populate cells in a row or column with the elements of an array

[Hermac]

Hello
This should be a simple problem but I'm not familiar with arrays. So please bear with me for a couple of minutes.
Let's take MyArray = ("John", "Jessica" , "Walter", "" , "Peter", "Jack", "Mary") , just to spread those names over [A1:G1] with a minimum of code.
I suppose an array is the shortest way. Is the "" between Walter en Peter necessary or will an ampty space between commas do?
And one more question, how many elements can an array carry?
Thank you very much.
Herman

 

[James006]

Hi,
You can test:

Sheet1.Cells(1).Resize(, UBound(MyArray, 1) + 1) = MyArray

 

[Peter_SSs]

What about

Range("A1:G1").Value = Array("John", "Jessica", "Walter", "", "Peter", "Jack", "Mary")

 

[Peter_SSs]

, how many elements can an array carry?

As many as your machine's memory will allow as far as I know. Should be millions.

 

[Hermac]

Thanks a lot Peter and James. I knew it wouldn't be to hard to do but it's very helpful and saved me a lot of surftime.

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.