truncate worksheet name if >31 characters to worksheet

[3345james]

This code works great for creating worksheets from a list. However some names on the list are longer than the 31 characters allowed. Is there a way to edit this code to truncate the name if larger than 31 characters?

Please Login or Register  to view this content.

[skywriter]

Maybe this.

Please Login or Register  to view this content.

[3345james]

Thanks - that works
Appreciate your time and effort.

[skywriter]

My pleasure, thanks for the feedback and rep. points.