Excel Object Model: Global

Excel's Global object is a hidden object that allows to refer to objects in VBA code in an abbreviated form, for example simply cells instead of application.cells.

Because the object is hidden, it can be seen in the Object Browser only if showing hidden members is explicitly enabled (right click on the classes pane).

Properties and methods

`activeCell`
`activeChart`
`activeDialog`	A hidden member
`activeMenuBar`	A hidden member
`activePrinter`
`activeSheet`
`activeWindow`
`activeWorkbook`
`addIns`
`application`
`assistant`	A hidden member
`calculate()`
`cells`
`charts`
`columns`
`commandBars`
`creator`
`DDEAppReturnCode`
`DDEExecute()`
`DDEInitiate()`
`DDEPoke()`
`DDERequest()`
`DDETerminate()`
`dialogSheets`	A hidden member
`equals`
`evaluate()`
`_evaluate()`	A hidden member
`excel4IntlMacroSheets`
`excel4MacroSheets`
`executeExcel4Macro`
`intersect`	Compare with `union()`
`menuBars`	A hidden member
`modules`	A hidden member
`names`
`parent`
`range`
`rows`
`run()`
`_run2()`	A hidden member
`selection`
`sendKeys()`
`sheets`
`shortcutMenus`	A hidden member
`thisWorkbook`
`toolbars`	A hidden member
`union()`	Compare with `intersect()`
`windows`
`workbooks`
`worksheetFunction`
`worksheets`

Links

When I researched the Global object, the following two Stackoverflow answers were particularly helpful to me:

Excel Object Model: Global

Properties and methods

See also

Links