PDA

View Full Version : [SOLVED:] Text outcome coming out reversed



BigDawg15
08-07-2015, 08:14 AM
Found the code in the attached workbook on this site (I believe), but can't seem to get the text to print out

not reversed. e.g. John currently comes out as nhoJ.

I see in the code where the reverse is being implemented, but do not understand vba enough to fix it.

Any help is appreciated.

Thank you,

BigDawg15

Kenneth Hobs
08-07-2015, 08:55 AM
Simply uncomment the comment and comment the other that does the StrReverse()? e.g.

'Sp2 = Split(StrReverse(str), ",")
Sp2 = Split(str, ",")

BigDawg15
08-07-2015, 09:01 AM
Kenneth,

Thank you for the reply. I have tried doing what you suggested however, when I do that, the first tier is not
filled in like it is when the reverse code is run.

Thank you,

BigDawg15

Kenneth Hobs
08-07-2015, 11:24 AM
Maybe:

'fray(Rw, s + 1) = Sp2(s)
fray(Rw, s + 1) = StrReverse(Sp2(s))

BigDawg15
08-07-2015, 12:31 PM
Thank you sir! That was it.
Much appreciated.

Regards,

BigDawg15