Hi Garry
Yes, Gord just tool me 30 characters max. I will create a column with
abbreviated names.
Great support from you guys.
Thanks
Cimjet
"GS" wrote in message ...
I think there might be a limit to the number of characters you can use for
sheetnames. Also, when renaming sheets via VBA with names that contain spaces
or other non alpha-numeric characters, the name should be wrapped in
apostrophes.

Your methodology for naming sheets as per customer/invoice number is probably
not the best way to handle this. Not saying there's anything wrong with doing
it this way, though if you want to persist I suggest you reduce the customer
name portion to a customer code abbreviation or some other truncated
methodology like this:

GENFOOT INC. - DIVISION IMD (Kamik)
could be truncated to...
GENFOOT-IMD_<Inv#
or...
GENINC-DIVIMD_<Inv# if the above isn't enough to identify the sheet.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc