Variable VBA Array Lengths, insert into cell as string

[Speshul]

Awkward title but oh well...

I've never played with VBA arrays, but need to for a project...so, here is the basic array i have built for this;

Please Login or Register  to view this content.

Simple enough.
My array (bl) needs to contain a list of the values in H8 through H23. it works fine, those values do enter the array, or at least that's what my MsgBox bl(4) test told me.

What I need to happen is the array gets spit into a cell separated by delimiting characters.

For example, if;

H8 = "APPLE"
H9 = "DOG"
H10 = "PIANO"

The output I am looking to get is
'APPLE','DOG','PIANO'

My bigger question is, how do I get that output from an array of up to 16 values? I know I could;
"'" & bl(0) & "'.'" & bl(1) & "','" * bl(2)...... and so on to 15, but my output would end up being;
'APPLE','DOG','PIANO','','','','','','','','','','','','','',' And while this would work, I would prefer to not have blanks.

Thanks in advance!

[mikerickson]

You could use

Please Login or Register  to view this content.