You are using variables which I cannot figure out what they really represent and do, and how you get their values:
Go to msdn.microsoft.com and search for "excel constants" - this should return a list of pages - the first one of them will bring you to a page that defines each of the constants and their values. Each value has a specific meaning, as you will see. The page I'm looking at is http://msdn2.microsoft.com/en-us/library/aa221100(office.11).aspx.
When programming in VB, there are include files that define readonly vars with these values, thus they are "constants". The only way to simulate this in Kix is to declare them as globals, but they won't be read-only. This way, you use the constant name instead of the number, which makes reading the source code much easier. I thought about adding some commonly used values as Globals in my xlLib UDFs, but wasn't sure of the impact of so many vars. Maybe after more testing.
Anyway, that's where these weird numbers come from... (and how you can figure out what they mean and where to use them)
Glenn
_________________________
Actually I
am a Rocket Scientist!
