Scramble function

[zz]

I'm mind blocked!!

I'm trying to generate a routine that randomly scrambles the characters in a
string, but i'm having real trouble regenerating the string to it's original
state, has anyone ever done this in VBA?

 

[Dave]

ok, so you randomly scramble the characters, how would you expect to be able
to put them back? have you kept some kind of record of where they started??
why not just save the original string and make a copy of it to scramble?

 

[zz]

Sorry i missed that point

actually i don't randomly scramble the characters in the string, i have 4
arrays with numbers and letter, with both right ti left and left to right
order., i'm scrambling the characters based on the index of the letter in
the letters array, the same when the string contains numeric characters