Adding Items to a Collection

[SBF12345]

Greetings,

I would like to add a range of columns to a collection and then use the collection in a for each loop including each column-element in the collection in a procedure. like,

Dim i As String
For Each i in col

Is there a more convenient syntax than something like

col.add F

I would like to add all the column values at once if possible

Thanks!

 

[ranman256]

Collections can only add 1 item at a time.

 

[SBF12345]

hmmm...is there a similar object that would allow me to include multiple string variables as part of a group?