Philip,

Enum types are not supported in Excel97. They are supported in Excel 2000
and later versions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Philip Mariconda" wrote in message
...
Excel 97 help and MSDN provide surprisingly little
information on the proper declaration of Enum constants.
It seems they need to be declared at module level and not
at procedure level.

However, when I type...

Public Enum iRegion

...just like an MSDN code example it's a syntax error.
Are Enum types only used in class modules?

Thanks!
Phil