gauntletxg
Well-known Member
- Joined
- Jul 15, 2008
- Messages
- 636
Say I have a string, "a test array." I want to split this into an array where each character is an element. I was thinking something like
But this doesn't work because Split() returns the entire string when the delimiter is a zero-length string. How would I go about doing this?
Thanks.
Code:
Dim MyArray As Variant
Dim MyString As String
MyString = "a test array"
MyArray = Split(MyString, "", Len(MyString), vbTextCompare)
But this doesn't work because Split() returns the entire string when the delimiter is a zero-length string. How would I go about doing this?
Thanks.