Microsoft Office Tutorials and References
In Depth Information
Table 18-2. Members That Return Objects
ChartObjects
MailEnvelope<v10>
Scripts<v9>
CheckBoxes
Move
ScrollArea
CheckSpelling
Name
ScrollBars
CircleInvalid
Names
Select
CircularReference
Next
SetBackgroundPicture
ClearArrows
OLEObjects
Shapes
ClearCircles
OnCalculate
ShowAllData
CodeName
OnData
ShowDataForm
Columns
OnDoubleClick
SmartTags<v10>
Comments
OnEntry
Spinners
ConsolidationFunction
OnSheetActivate
StandardHeight
ConsolidationOptions
OnSheetDeactivate
StandardWidth
ConsolidationSources
OptionButtons
Tab<v10>
Copy
Outline
TextBoxes
Creator
Ovals
TransitionExpEval
CustomProperties<v10>
PageSetup
TransitionFormEntry
Delete
Parent
Type
DisplayAutomaticPageBreaks
Paste
Unprotect
DisplayPageBreaks
PasteSpecial
UsedRange
DisplayRightToLeft
Pictures
Visible
DrawingObjects
PivotTables
VPageBreaks
Drawings
PivotTableWizard
Many of the members in Table 18-1 exist solely to return the children of the Worksheet object.
These members and their return types are shown in Table 18-2 .
Table 18-2. Members That Return Objects
Name
ReturnType
Application
Application
AutoFilter
AutoFilter
Cells
Range
CircularReference
Range
Columns
Range
Comments
Comments
CustomProperties
CustomProperties
HPageBreaks
HPageBreaks
Hyperlinks
Hyperlinks
Names
Names
Outline
Outline
PageSetup
PageSetup
PivotTableWizard
PivotTable
Protection
Protection
QueryTables
QueryTables
Range
Range
Rows
Range
Shapes
Shapes
 
 
Search JabSto ::




Custom Search