Mark Simms
marksimms at verizon.net
Thu Feb 2 19:31:54 CST 2012
David - that's dangerous practice. All you needed was a VBA Reference to the Excel 12 (or 14) Object Library. Then you can reference any of the Excel constants or enumerations with meaningful names. I'm working on a complex workbook where the original developer never used constants or enumerations. Everything was a million references to hard-coded integers.....quite abstract and very hard to understand and/or modify. > > I finally figured it out! > I found a link with Excel Constants: >