In my macro, what code would I need to have to have my worksheet name be 6 characters long? (Or any set number of characters for that matter.)

I also posted this on mrexcel.com with this link:

https://www.mrexcel.com/forum/excel-...heet-name.html