Maximum Sheet Name Length Constant

Question

Is there a property or constant available in VBA that can tell me what the maximum allowed length of a sheet name is? I want to set a sheet name programmatically based on user input and I need to make sure the name provided does not exceed the limit. I found many code examples where this is hard-set as 31 characters, but I would like to avoid doing so if there is a constant or property that can provide me this information in case the limit is increased in a future version of Excel.

Answer 1

As far as I know, there is no such property. You could create such a constant yourself at the top of a module:

Public Const MaxSheetNameLength = 31

and refer to the constant in your code.

If it changes in the future, you'll only have to change the value of the constant.

---

Regards, Hans Vogelaar

Answer 2

I figured there wasn't and what you suggested is what I already did. Thanks Hans.