Namining Conventions for NAMED ranges.

[bill]

OMG, could there ever be a more beautiful object model?

Anyway, when defining NAMED RANGES what are naming conventions?

I know " " and "-" are invalid.

Anything else?

Thanks?

 

[Smitty]

From the Excel Help File for "range names"

Guidelines for naming cells, formulas, and constants in Microsoft Excel
What characters are allowed? The first character of a name must be a letter or an underscore character. Remaining characters in the name can be letters, numbers, periods, and underscore characters.

Can names be cell references? Names cannot be the same as a cell reference, such as Z$100 or R1C1.

Can more than one word be used? Yes, but spaces are not allowed. Underscore characters and periods may be used as word separators — for example, Sales_Tax or First.Quarter.

How many characters? A name can contain up to 255 characters.

Note If a name defined for a range contains more than 253 characters, you cannot select it from the Name box.

Are names case sensitive? Names can contain uppercase and lowercase letters. Microsoft Excel does not distinguish between uppercase and lowercase characters in names. For example, if you have created the name Sales and then create another name called SALES in the same workbook, the second name will replace the first one.

Hope that helps,

Smitty

 

[bill]

I suppose you're using a version of EXCEL greater than 97 because I could not seem to find it...

Seems, the convention is the same as that used for variable naming.

Thanks for the ino!

Bill

 

[Smitty]

Sorry,

I'm on XL2000.