I pulling my hair on this one. Split is not working.
Dim sometext as string
myArr() = Split(sometext, vbCrLf)
Sample data. The data is stored on sometext variable already.
Code:“ajkdhaljkhlkjaddfj ka gdkjgaslkjdgasjkd”: asjkldh dfjkljgsd glakfjsfadj aldkjalkjs sl sdklfjslk fsdlkf aldjkaklsd asd klasdlkjaslkd asdjasd.Code:under immediate window when i try debug.print myArr(0) “ajkdhaljkhlkjaddfj ka gdkjgaslkjdgasjkd”: asjkldh dfjkljgsd glakfjsfadj aldkjalkjs sl sdklfjslk fsdlkf aldjkaklsd asd klasdlkjaslkd asdjasd. myArr(1) will return an error.
Can somebody help me on this one?




Reply With Quote