VBA Create and Rename Sheets

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

I'm using the code below to create a new worksheet for each line manager whose name appears in n column R of the "Unique Records" sheet.

Please Login or Register  to view this content.

The code works fine, but I'm having a little difficulty in changing one line of the code.

Please Login or Register  to view this content.

This line of code applies the 'Managers Name' to each sheet, but I'm looking to change this so the sheet name becomes "Activity Breakdown - 'Line Manager Name'"

I've been able to change the line to

Please Login or Register  to view this content.

and each sheet name correctly displays the hyphen.

But when I try to change the line to:

Please Login or Register  to view this content.

I receieve an error message.

I just wondered whether someone could look at this please and offer some guidance on where I'm going wrong.

Many thanks and kind regards

[Norie]

You might be breaking the limit for the no of characters you can have in a worksheet name.

Off the top of my head that limit is 31/32 characters, and 'Activity Breakdown - ' already gives you 20 characters.

[adyteo]

What is the error message?

[hobbiton73]

Hi @Norie, thank you for taking the time to reply to my post.

I've continued to work on this since my post and ExcelForum added this to the site and you are quite correct, it was an issue with the number of characters.

All the best and kind regards

[hobbiton73]

Hi @adyteo, thank you for taking the time to reply to my post.

As you will see in my reply to @Norie, I've been able to resolve this issue.

Many thanks and kind regards