HELP - Code to Copy/Format/Save/Print Worksheet Based on Cell Values

Hi,

I currently have a code that copies a worksheet in WB1, creates a new WB and renames the newly created file then saves it based on the value of two cells within the new WB.

The issue I have been facing is that once the values from the two cells combined become longer then 31 characters, the VB coding bugs out and returns an error message saying Run-time Error '1004'.

The coding I am using atm is:

Please Login or Register  to view this content.

Can anyone please advise how i can get around this bug and allow me to rename and save the new WB based on cells having values over 31 characters?

The two key cells i am trying to reference is G7 & B13.

Thank you.

What cell contains the name of the new workbook and what cell contains the new worksheet?

can anyone help me with the issue of the macro bugging out when the combined characters of the two cell is more then 31 characters?

could you attach a sample copy of the workbook as well?

what if you take only the first 20 characters of the company name?

Please Login or Register  to view this content.

the limit is only for the Sheet name, not for the actual file name, so you can still save the filename as long as you want, but the sheet name needs to be less than 31 char in length.