I have created an array by using the split function.
ClientWords = Split(Trim(txt))
I would like to do a redim preserve to add an extra element so I can mark a specific word in the array.
How do i do that
I tried ReDim Preserve ClientWords(UBound(ClientWords),0)
but i get subscript out of range