-
What i do to get lists of constant values and other similar stuff is:
copy the constant list from Help (or whenever I can find it)
check in the Object Browser that they're all there
Paste into colB in excel
type "debug.print " in A1 and drag down
type formula "=A1&B1" in C1 and drag down
copy the resulting colC to a routine, run and get the corresponding values from the Immediate window
It seems quite long-winded but it doesn't take to long to get what you need.
K :-)

Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules