String to Array

[Leandroarb]

Hi everybody!

Is possible defining a variable type array with other variable type string?

Dim strLinhas As Variant


strLinhas = Array(strLstSemBdo)

strLstSemBdo is a variable maked from a loop, selecting rows numbers.

Her can be:

 52, 67, 130, 137, 155, 279, 370, 402, 417, 421, 423, 430, 458, 459, 476

Thanks in advance!

 

[Fluff]

How about

strLinhas = Split(strLstSemBdo, ", ")

 

[Leandroarb]

Thank you very much Mr. Pluff! It worked!

 

[Fluff]

You're welcome & thanks for the feedback