Hi Hilmar.

I can't for the life of me remember how to obtain, within Excel, the numeric value of a constant from a macro saved in Excel (for instance, when creating borders, lots of constants are used), or where to obtain a *.H file, or any other reference.

Another approach is to go to http://www.west-wind.com/Webtools.asp and click on the link at the bottom of the page to download GetConstants.exe. You feed it a TypeLib and it creates a .h file for you. That's my preferred method < s >.