I've looked at several threads on the forum relating to spliting a string, however there not quite answering the problem I have:
Within VBA I have a string that is actually taken from a cell, this could be any length and is a list of usernames seperated by a coma.
What I need to be able to do is split this string into an array, with each user name appearing in a different element of the array, i.e:
OrginalString = Fred,Smith
Split down to:
String(0) = Fred
String(1) = Smith
Does this make sense, any suggestions would be greatly recieved,