Just make sure you add tons of error checking before doing this - check for things like null input strings before splitting - most important, make sure the UBound is > 0 before proceeding. This kind of processing deserves much error clecking.