Use of a Userform to Create copies of hidden Excel sheets

Hi Harry,

I'm working on your problem.

Some of the Sheet names exceed the Excel 31 Character limitation when there is a duplicate. For example, 'Arrival_Port5_Discharge_Jul31(2)' is 32 characters long and 'Progress_Port5_Discharge_Jul31(2)' is 33 characters long.

Lewis

Originally Posted by LJMetzger

Hi Harry,

I'm working on your problem.

Some of the Sheet names exceed the Excel 31 Character limitation when there is a duplicate. For example, 'Arrival_Port5_Discharge_Jul31(2)' is 32 characters long and 'Progress_Port5_Discharge_Jul31(2)' is 33 characters long.

Lewis

Thanks Lewis. Perhaps another way around that 31 character limitation is to use only the first 4 letters of the first word, in this case instead of 'Arrival_Port5_Discharge_Jul31(2)' it can be "Arri__Port5_Discharge_Jul31(2)"

Thanks!!!