View Single Post
  #5   Report Post  
Dana DeLouis
 
Posts: n/a
Default

Be aware of the "!" character also. You may have an error when using [...]
addressing.
For example, you can name a sheet with this character. For example
"Sheet!2"

This works...
[Sheet1].Select

But this would not work...
[Sheet!2].Select

HTH
--
Dana DeLouis
Win XP & Office 2003


"sparky" wrote in message
...
I am creating workbooks through a programmatic interface and need to know
what constraints there are on worksheet names. I understand that they have
to
be no more than 31 (or 32?) characters in length, but are there other
rules
like allowable characters that I need to be aware of?