Hale handling String variable in VBA

[Dante Sparda]

I've got some String variable in vba

and it contains a textof a few lines, I need to save each line of the text in another string varable.

 

How can I do that??

 

 

thanks!!

 

Edit: in the title, where it says hale, I mean help don't know why I typed that

[MSasu]

Should use SPLIT statement with an adequate character as separator – in your case I suppose will be Chr(13) = since you say is about “lines” of text.

This will return a list (array) with those lines.

 

Regards,