Hi, I wonder whether someone may be able to help me please.
I'm using the code below to create worksheets from the value in a specific cell range.
The issue I have is that I know in Excel 2003 there is a sheet name length of 31 charcters, so when the code finds a cell value greater than this, it throws an error.![]()
Please Login or Register to view this content.
This is the line which creates the sheet name .Name = UqPo(i, 1). Could someone perhaps tell me please is there a way whereby when the script reaches a cell with a value greater than 31 characters, when it creates the sheet, it automatically shortens the sheet name to 30 charcaters and then a full stop to reach the 31 character maximum.
Many thanks and kind regards
Chris
Bookmarks