xl

[noyb]

When reading this forum I see numerous references to "xl<something>" but
I can't find references to these variables?? by searching help for xl in
either VBE or Excel. Would someone please give me a jump start in this
area? For instance where does one find reference to these ?? in the help
system?
Thanks

 

[Bob Phillips]

Give an example so that we know what you mean.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

You mean the constants such as xlCalculationManual or xlCalculationAutomatic.
Press F2 while in the VBE to open the object browser and you can search the
libraries for them.

 

[Tom Ogilvy]

Are you talking about defined constants like

xlToLeft

xlup

these can be found in the help with the functions they are used with.

You can also search for them in the Object browser in the VBE. If you
select one in the object browser, in the bottom of the window you will see
the value the constant represents.