Append a Tab Name

[HangMan]

I'm using this code to name tabs in a workbook when being a sinlge Workbook is split into multiple Worksheets:

Please Login or Register  to view this content.

Wat is the correct syntax to use if I want to append the filename, for example, if I wanted to add 'ABC' at the start of each tab name or 'XYZ' at the end of each tab name, whilst maintaining the 31 characcter limit?

Many thanks

[ragulduy]

I would assume you would change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[MarvinP]

Does

Left(ThisWorkbook.Name & MyArr(Itm),31)

work?

I like yudlugar's answer better. It seems you are simply asking how to append a string together before trimming it to 31 character length.??

I'm not sure I understand the entire question...

[HangMan]

Hi yudlugar,

That's exactly what I had previously tried, but realise now I put the "ABC " & in the wrong place. All working now, many thanks...