documentation
.HELP!
Microsoft Excel Visual Basic Documentation
Name Object Model
Microsoft Excel Visual Basic
previous page
next page
Name Object
Name
Range
Areas
Borders
Border
Characters
Comment
Shape
Errors
Error
Font
FormatConditions
Hyperlinks
Interior
ListObject
ListColumns
ListRows
XmlMap
Phonetic
Phonetics
PivotCell
PivotItemList
PivotField
CubeField
PivotItem
PivotTable
CalculatedMembers
CubeFields
PivotFormulas
QueryTable
Parameters
SoundNote
Validation
Worksheet
AutoFilter
Comments
CustomProperties
HPageBreaks
ListObjects
Names
Outline
PageSetup
Protection
QueryTables
Shapes
Tab
VPageBreaks
XPath
XmlMap
Legend
Object and collection
Object only
previous page
start
next page
Menu
Homepage
Table of contents
Microsoft Excel Visual Basic Reference
Microsoft Excel Object Model
What's New
New Objects
New Properties (Alphabetic List)
New Properties (by Object)
New Methods (Alphabetic List)
New Methods (by Object)
New Events
Programming Concepts
Workbooks and Worksheets
Creating a New Workbook
Opening a Workbook
Referring to Sheets by Index Number
Referring to Sheets by Name
Saving Documents as Web Pages
Cells and Ranges
How to Reference Cells and Ranges
Looping Through a Range of Cells
Selecting and Activating Cells
Working with 3-D Ranges
Working with the Active Cell
Controls, Dialog Boxes, and Forms
Using ActiveX Controls on Sheets
Using ActiveX Controls on a Document
Creating a Custom Dialog Box
Using Microsoft Office Web Components on Forms
Built-In Dialog Box Argument Lists
Events, Worksheet Functions, and Shapes
Using Events with Microsoft Excel Objects
Using Microsoft Excel Worksheet Functions in Visual Basic
Working with Shapes (Drawing Objects)
Working with Other Applications
Controlling One Microsoft Office Application from Another
OLE Programmatic Identifiers
Collections
A
AddIns Collection
AllowEditRanges Collection
Areas Collection
Axes Collection
B
Borders Collection
C
CalculatedFields Collection
CalculatedItems Collection
CalculatedMembers Collection
ChartGroups Collection
ChartObjects Collection
Charts Collection
Comments Collection
CubeFields Collection
CustomProperties Collection
CustomViews Collection
D
DataLabels Collection
DiagramNodes Collection
Dialogs Collection
E
Errors Collection
F
Filters Collection
FormatConditions Collection
H
HPageBreaks Collection
Hyperlinks Collection
L
LegendEntries Collection
ListColumns Collection
ListObjects Collection
ListRows Collection
N
Names Collection
O
ODBCErrors Collection
OLEDBErrors Collection
OLEObjects Collection
P
Panes Collection
Parameters Collection
Phonetics Collection
PivotCaches Collection
PivotFields Collection
PivotFormulas Collection
PivotItemList Collection
PivotItems Collection
PivotTables Collection
Points Collection
PublishObjects Collection
Q
QueryTables Collection
R
Range Collection
RecentFiles Collection
S
Scenarios Collection
SeriesCollection Collection
ShapeNodes Collection
ShapeRange Collection
Shapes Collection
Sheets Collection
SmartTagActions Collection
SmartTagRecognizers Collection
SmartTags Collection
Styles Collection
T
Trendlines Collection
U
UsedObjects Collection
UserAccessList Collection
V
VPageBreaks Collection
W
Watches Collection
Windows Collection
Workbooks Collection
Worksheets Collection
X
XmlMaps Collection
XmlNamespaces Collection
XmlSchemas Collection
Objects
A
AddIn Object
Adjustments Object
AllowEditRange Object
Application Object
AutoCorrect Object
AutoFilter Object
AutoRecover Object
Axis Object
AxisTitle Object
B
Border Object
C
CalculatedMember Object
CalloutFormat Object
CellFormat Object
Characters Object
Chart Object
ChartArea Object
ChartColorFormat Object
ChartFillFormat Object
ChartGroup Object
ChartObject Object
ChartTitle Object
ColorFormat Object
Comment Object
ConnectorFormat Object
ControlFormat Object
Corners Object
CubeField Object
CustomProperty Object
CustomView Object
D
DataLabel Object
DataTable Object
DefaultWebOptions Object
Diagram Object
DiagramNode Object
DiagramNodeChildren Object
Dialog Object
DisplayUnitLabel Object
DownBars Object
DropLines Object
E
Error Object
ErrorBars Object
ErrorCheckingOptions Object
F
FillFormat Object
Filter Object
Floor Object
Font Object
FormatCondition Object
FreeformBuilder Object
G
Graphic Object
Gridlines Object
GroupShapes Object
H
HiLoLines Object
HPageBreak Object
Hyperlink Object
I
Interior Object
IRtdServer Object
IRTDUpdateEvent Object
L
LeaderLines Object
Legend Object
LegendEntry Object
LegendKey Object
LineFormat Object
LinkFormat Object
ListColumn Object
ListDataFormat Object
ListObject Object
ListRow Object
M
Mailer Object
N
Name Object
O
ODBCError Object
OLEDBError Object
OLEFormat Object
OLEObject Object
Outline Object
P
PageSetup Object
Pane Object
Parameter Object
Phonetic Object
PictureFormat Object
PivotCache Object
PivotCell Object
PivotField Object
PivotFormula Object
PivotItem Object
PivotLayout Object
PivotTable Object
PlotArea Object
Point Object
Protection Object
PublishObject Object
Q
QueryTable Object
R
RecentFile Object
RoutingSlip Object
RTD Object
S
Scenario Object
Series Object
SeriesLines Object
ShadowFormat Object
Shape Object
ShapeNode Object
SmartTag Object
SmartTagAction Object
SmartTagOptions Object
SmartTagRecognizer Object
SoundNote Object
Speech Object
SpellingOptions Object
Style Object
T
Tab Object
TextEffectFormat Object
TextFrame Object
ThreeDFormat Object
TickLabels Object
TreeviewControl Object
Trendline Object
U
UpBars Object
UserAccess Object
V
Validation Object
VPageBreak Object
W
Walls Object
Watch Object
WebOptions Object
Window Object
Workbook Object
Worksheet Object
WorksheetFunction Object
X
XmlDataBinding Object
XmlMap Object
XmlNamespace Object
XmlSchema Object
XPath Object
Methods
A
AcceptAllChanges Method
Activate Method
ActivateMicrosoftApp Method
ActivateNext Method
ActivatePrevious Method
Add Method
AddCallout Method
AddChartAutoFormat Method
AddComment Method
AddConnector Method
AddCurve Method
AddCustomList Method
AddDataField Method
AddDiagram Method
AddFields Method
AddFormControl Method
AddItem Method
AddLabel Method
AddLine Method
AddMemberPropertyField Method
AddNode Method
AddNodes Method
AddOLEObject Method
AddPageItem Method
AddPicture Method
AddPolyline Method
AddReplacement Method
AddSet Method
AddShape Method
AddTextbox Method
AddTextEffect Method
AddToFavorites Method
AdvancedFilter Method
Align Method
Apply Method
ApplyCustomType Method
ApplyDataLabels Method
ApplyNames Method
ApplyOutlineStyles Method
AreaGroups Method
Arrange Method
AutoComplete Method
AutoFill Method
AutoFilter Method
AutoFit Method
AutoFormat Method
AutomaticLength Method
AutoOutline Method
AutoShow Method
AutoSort Method
Axes Method
B
BarGroups Method
BeginConnect Method
BeginDisconnect Method
BorderAround Method
BreakLink Method
BreakSideBySide Method
BringToFront Method
BuildFreeform Method
C
Calculate Method
CalculatedFields Method
CalculatedItems Method
CalculateFull Method
CalculateFullRebuild Method
CancelRefresh Method
CanCheckIn Method
CanCheckOut Method
CentimetersToPoints Method
ChangeFileAccess Method
ChangeLink Method
ChangePassword Method
ChangeScenario Method
Characters Method
ChartGroups Method
ChartObjects Method
ChartWizard Method
CheckAbort Method
CheckIn Method
CheckOut Method
CheckSpelling Method
CircleInvalid Method
Clear Method
ClearArrows Method
ClearCircles Method
ClearComments Method
ClearContents Method
ClearFormats Method
ClearNotes Method
ClearOutline Method
ClearSettings Method
CloneNode Method
Close Method
ColumnDifferences Method
ColumnGroups Method
CompareSideBySideWith Method
ConnectData Method
Consolidate Method
Convert Method
ConvertFormula Method
ConvertToShape Method
Copy Method
CopyFromRecordset Method
CopyPicture Method
CreateCubeFile Method
CreateNames Method
CreateNewDocument Method
CreatePivotTable Method
CreatePublisher Method
CreateSummary Method
CustomDrop Method
CustomLength Method
Cut Method
D
DataLabels Method
DataSeries Method
DDEExecute Method
DDEInitiate Method
DDEPoke Method
DDERequest Method
DDETerminate Method
Delete Method
DeleteAll Method
DeleteChartAutoFormat Method
DeleteCustomList Method
DeleteNumberFormat Method
DeleteReplacement Method
Deselect Method
DialogBox Method
Dirty Method
Disconnect Method
DisconnectData Method
DisplayXMLSourcePane Method
Distribute Method
DoubleClick Method
DoughnutGroups Method
DragOff Method
Duplicate Method
E
EditionOptions Method
EndConnect Method
EndDisconnect Method
EndReview Method
ErrorBar Method
Evaluate Method
ExclusiveAccess Method
Execute Method
ExecuteExcel4Macro Method
Export Method
ExportXml Method
Extend Method
F
FillAcrossSheets Method
FillDown Method
FillLeft Method
FillRight Method
FillUp Method
Find Method
FindFile Method
FindNext Method
FindPrevious Method
Flip Method
Follow Method
FollowHyperlink Method
Format Method
ForwardMailer Method
FunctionWizard Method
G
GetChartElement Method
GetCustomListContents Method
GetCustomListNum Method
GetData Method
GetOpenFilename Method
GetPhonetic Method
GetPivotData Method
GetSaveAsFilename Method
GoalSeek Method
Goto Method
Group Method
H
Heartbeat Method
Help Method
HighlightChangesOptions Method
I
Import Method
ImportXml Method
InchesToPoints Method
IncrementBrightness Method
IncrementContrast Method
IncrementLeft Method
IncrementOffsetX Method
IncrementOffsetY Method
IncrementRotation Method
IncrementRotationX Method
IncrementRotationY Method
IncrementTop Method
InputBox Method
Insert Method
InsertIndent Method
InstallManifest Method
Intersect Method
Item Method
J
Justify Method
L
LargeScroll Method
LegendEntries Method
LineGroups Method
LinkInfo Method
LinkSources Method
List Method
ListFormulas Method
ListNames Method
LoadSettings Method
Location Method
M
MacroOptions Method
MailLogoff Method
MailLogon Method
MakeConnection Method
Merge Method
MergeWorkbook Method
Modify Method
Move Method
MoveNode Method
N
NavigateArrow Method
NewSeries Method
NewWindow Method
Next Method
NextLetter Method
NextNode Method
NoteText Method
O
OLEObjects Method
OneColorGradient Method
OnKey Method
OnRepeat Method
OnTime Method
OnUndo Method
Open Method
OpenDatabase Method
OpenLinks Method
OpenText Method
OpenXML Method
P
Parse Method
Paste Method
PasteSpecial Method
Patterned Method
PickUp Method
PieGroups Method
PivotCache Method
PivotCaches Method
PivotFields Method
PivotItems Method
PivotSelect Method
PivotTables Method
PivotTableWizard Method
Play Method
Points Method
PointsToScreenPixelsX Method
PointsToScreenPixelsY Method
Post Method
PresetDrop Method
PresetGradient Method
PresetTextured Method
Previous Method
PrevNode Method
PrintOut Method
PrintPreview Method
Protect Method
ProtectSharing Method
Publish Method
PurgeChangeHistoryNow Method
Q
Quit Method
R
RadarGroups Method
RangeFromPoint Method
RecheckSmartTags Method
Record Method
RecordMacro Method
Refresh Method
RefreshAll Method
RefreshData Method
RefreshTable Method
RegisterXLL Method
Regroup Method
RejectAllChanges Method
ReloadAs Method
RemoveAllItems Method
RemoveItem Method
RemoveSubtotal Method
RemoveUser Method
Repeat Method
Replace Method
ReplaceNode Method
Reply Method
ReplyAll Method
ReplyWithChanges Method
RerouteConnections Method
Reset Method
ResetAllPageBreaks Method
ResetColors Method
ResetPositionsSideBySide Method
ResetRotation Method
ResetTimer Method
Resize Method
RestartServers Method
Route Method
RowDifferences Method
RTD Method
Run Method
RunAutoMacros Method
S
Save Method
SaveAs Method
SaveAsODC Method
SaveAsXMLData Method
SaveCopyAs Method
SaveWorkspace Method
ScaleHeight Method
ScaleWidth Method
Scenarios Method
ScrollIntoView Method
ScrollWorkbookTabs Method
Select Method
SelectAll Method
SendFaxOverInternet Method
SendForReview Method
SendKeys Method
SendMail Method
SendMailer Method
SendToBack Method
SeriesCollection Method
ServerStart Method
ServerTerminate Method
SetBackgroundPicture Method
SetDefaultChart Method
SetEditingType Method
SetExtrusionDirection Method
SetLinkOnData Method
SetParam Method
SetPasswordEncryptionOptions Method
SetPhonetic Method
SetPosition Method
SetSegmentType Method
SetShapesDefaultProperties Method
SetSourceData Method
SetThreeDFormat Method
SetValue Method
Show Method
ShowAllData Method
ShowDataForm Method
ShowDependents Method
ShowErrors Method
ShowLevels Method
ShowPages Method
ShowPrecedents Method
SmallScroll Method
Solid Method
Sort Method
SortSpecial Method
Speak Method
SpecialCells Method
SubscribeTo Method
Subtotal Method
SwapNode Method
T
Table Method
Text Method
TextToColumns Method
ToggleVerticalText Method
TransferChildren Method
Trendlines Method
TwoColorGradient Method
U
Undo Method
Ungroup Method
Union Method
Unlink Method
Unlist Method
UnMerge Method
Unprotect Method
UnprotectSharing Method
Update Method
UpdateChanges Method
UpdateFromFile Method
UpdateLink Method
UpdateNotify Method
UseDefaultFolderSuffix Method
UserPicture Method
UserTextured Method
V
Verb Method
Volatile Method
W
Wait Method
WebPagePreview Method
X
XmlDataQuery Method
XmlImport Method
XmlImportXml Method
XmlMapQuery Method
XYGroups Method
Z
ZOrder Method
Properties
A
Accent Property
AcceptLabelsInFormulas Property
Active Property
ActiveCell Property
ActiveChart Property
ActivePane Property
ActivePrinter Property
ActiveSheet Property
ActiveWindow Property
ActiveWorkbook Property
ActiveXControl Property
AddIndent Property
AddIns Property
Address Property
AddressLocal Property
AdjustColumnWidth Property
Adjustments Property
ADOConnection Property
AlertBeforeOverwriting Property
AlertStyle Property
Alignment Property
AllowDeletingColumns Property
AllowDeletingRows Property
AllowEdit Property
AllowEditRanges Property
AllowFillIn Property
AllowFiltering Property
AllowFormattingCells Property
AllowFormattingColumns Property
AllowFormattingRows Property
AllowInsertingColumns Property
AllowInsertingHyperlinks Property
AllowInsertingRows Property
AllowPNG Property
AllowSorting Property
AllowUsingPivotTables Property
AlternativeText Property
AltStartupPath Property
AlwaysSaveInDefaultEncoding Property
Angle Property
AnswerWizard Property
AppendOnImport Property
Application Property
ApplyPictToEnd Property
ApplyPictToFront Property
ApplyPictToSides Property
ArabicModes Property
ArbitraryXMLSupportAvailable Property
Area3DGroup Property
Areas Property
AskToUpdateLinks Property
Assistant Property
Author Property
AutoAttach Property
AutoCorrect Property
AutoExpandListRange Property
AutoFilter Property
AutoFilterMode Property
AutoFormat Property
AutoFormatAsYouTypeReplaceHyperlinks Property
AutoLayout Property
AutoLength Property
AutoLoad Property
AutoMargins Property
AutomaticStyles Property
AutomationSecurity Property
AutoPercentEntry Property
AutoRecover Property
AutoRepublish Property
AutoScaleFont Property
AutoScaling Property
AutoShapeType Property
AutoShowCount Property
AutoShowField Property
AutoShowRange Property
AutoShowType Property
AutoSize Property
AutoSortField Property
AutoSortOrder Property
AutoText Property
AutoUpdate Property
AutoUpdateFrequency Property
AutoUpdateSaveChanges Property
AxisBetweenCategories Property
AxisGroup Property
AxisTitle Property
B
BackColor Property
Background Property
BackgroundChecking Property
BackgroundQuery Property
Backward Property
Bar3DGroup Property
BarShape Property
BaseField Property
BaseItem Property
BaseUnit Property
BaseUnitIsAuto Property
BCCRecipients Property
BeginArrowheadLength Property
BeginArrowheadStyle Property
BeginArrowheadWidth Property
BeginConnected Property
BeginConnectedShape Property
BeginConnectionSite Property
BlackAndWhite Property
BlackWhiteMode Property
Bold Property
Border Property
Borders Property
BottomMargin Property
BottomRightCell Property
Brightness Property
BubbleScale Property
BubbleSizes Property
Build Property
BuiltIn Property
BuiltinDocumentProperties Property
C
CacheIndex Property
CalculateBeforeSave Property
CalculatedMembers Property
Calculation Property
CalculationInterruptKey Property
CalculationState Property
CalculationVersion Property
Caller Property
Callout Property
CanPlaySounds Property
CanRecordSounds Property
CapitalizeNamesOfDays Property
Caption Property
Category Property
CategoryLocal Property
CategoryNames Property
CategoryType Property
CCRecipients Property
CellDragAndDrop Property
Cells Property
CenterFooter Property
CenterFooterPicture Property
CenterHeader Property
CenterHeaderPicture Property
CenterHorizontally Property
CenterVertically Property
ChangeHistoryDuration Property
ChangingCells Property
Characters Property
CharacterType Property
Chart Property
ChartArea Property
Charts Property
ChartSize Property
ChartTitle Property
ChartType Property
CheckboxState Property
CheckIfOfficeIsHTMLEditor Property
Child Property
ChildField Property
ChildItems Property
Children Property
Choices Property
CircularReference Property
ClipboardFormats Property
CLSID Property
CodeName Property
Color Property
ColorIndex Property
Colors Property
ColorType Property
Column Property
Column3DGroup Property
ColumnFields Property
ColumnGrand Property
ColumnItems Property
ColumnRange Property
Columns Property
ColumnWidth Property
COMAddIns Property
CommandBars Property
CommandText Property
CommandType Property
CommandUnderlines Property
Comment Property
Comments Property
ConflictResolution Property
Connection Property
ConnectionSiteCount Property
Connector Property
ConnectorFormat Property
ConsolidationFunction Property
ConsolidationOptions Property
ConsolidationSources Property
ConstrainNumeric Property
Container Property
Contrast Property
ControlCharacters Property
ControlFormat Property
CopyObjectsWithCells Property
Corners Property
CorrectCapsLock Property
CorrectSentenceCap Property
Count Property
CreateBackup Property
Creator Property
Criteria1 Property
Criteria2 Property
CropBottom Property
CropLeft Property
CropRight Property
CropTop Property
Crosses Property
CrossesAt Property
CubeField Property
CubeFields Property
CubeFieldType Property
CurrentArray Property
CurrentPage Property
CurrentPageList Property
CurrentPageName Property
CurrentRegion Property
Cursor Property
CursorMovement Property
CustomDocumentProperties Property
CustomListCount Property
CustomProperties Property
CustomSubtotalFunction Property
CustomViews Property
CutCopyMode Property
D
DashStyle Property
DatabaseSort Property
DataBinding Property
DataBodyRange Property
DataEntryMode Property
DataField Property
DataFields Property
DataLabel Property
DataLabelRange Property
DataPivotField Property
DataRange Property
DataTable Property
DataType Property
Date1904 Property
DDEAppReturnCode Property
DecimalPlaces Property
DecimalSeparator Property
DefaultFilePath Property
DefaultSaveFormat Property
DefaultSheetDirection Property
DefaultValue Property
DefaultWebOptions Property
Delivery Property
Dependents Property
Depth Property
DepthPercent Property
Destination Property
Diagram Property
DiagramNode Property
Dialogs Property
DictLang Property
DirectDependents Property
Direction Property
DirectPrecedents Property
DisplayAlerts Property
DisplayAutoCorrectOptions Property
DisplayBlanksAs Property
DisplayClipboardWindow Property
DisplayCommentIndicator Property
DisplayDocumentActionTaskPane Property
DisplayDrawingObjects Property
DisplayEmptyColumn Property
DisplayEmptyRow Property
DisplayEquation Property
DisplayErrorString Property
DisplayExcel4Menus Property
DisplayFormulaBar Property
DisplayFormulas Property
DisplayFullScreen Property
DisplayFunctionToolTips Property
DisplayGridlines Property
DisplayHeadings Property
DisplayHorizontalScrollBar Property
DisplayImmediateItems Property
DisplayInkComments Property
DisplayInsertOptions Property
DisplayNoteIndicator Property
DisplayNullString Property
DisplayOutline Property
DisplayPageBreaks Property
DisplayPasteOptions Property
DisplayRecentFiles Property
DisplayRightToLeft Property
DisplayRSquared Property
DisplayScrollBars Property
DisplaySmartTags Property
DisplayStatusBar Property
DisplayUnit Property
DisplayUnitCustom Property
DisplayUnitLabel Property
DisplayVerticalScrollBar Property
DisplayWorkbookTabs Property
DisplayZeros Property
DivID Property
DocumentLibraryVersions Property
DoughnutHoleSize Property
DownBars Property
DownloadComponents Property
DownloadURL Property
Draft Property
DragToColumn Property
DragToData Property
DragToHide Property
DragToPage Property
DragToRow Property
Drilled Property
DrilledDown Property
Drop Property
DropDownLines Property
DropLines Property
DropType Property
E
EditDirectlyInCell Property
EditingType Property
EditWebPage Property
Elevation Property
EmailSubject Property
EmbedSmartTags Property
EmptyCellReferences Property
EnableAnimations Property
EnableAutoComplete Property
EnableAutoFilter Property
EnableAutoRecover Property
EnableCalculation Property
EnableCancelKey Property
Enabled Property
EnableDataValueEditing Property
EnableDrilldown Property
EnableEditing Property
EnableEvents Property
EnableFieldDialog Property
EnableFieldList Property
EnableItemSelection Property
EnableMultiplePageItems Property
EnableOutlining Property
EnablePivotTable Property
EnableRefresh Property
EnableResize Property
EnableSelection Property
EnableSound Property
EnableWizard Property
Enclosures Property
Encoding Property
End Property
EndArrowheadLength Property
EndArrowheadStyle Property
EndArrowheadWidth Property
EndConnected Property
EndConnectedShape Property
EndConnectionSite Property
EndStyle Property
EntireColumn Property
EntireRow Property
EnvelopeVisible Property
ErrorBars Property
ErrorCheckingOptions Property
ErrorMessage Property
Errors Property
ErrorString Property
ErrorTitle Property
EvaluateToError Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
ExpandHelp Property
Explosion Property
ExtendList Property
Extent Property
ExtrusionColor Property
ExtrusionColorType Property
F
FeatureInstall Property
FetchedRowOverflow Property
FieldNames Property
FileConverters Property
FileDialog Property
FileFind Property
FileFormat Property
Filename Property
FileSearch Property
Fill Property
FillAdjacentFormulas Property
FilterMode Property
Filters Property
FindFormat Property
FirstChild Property
FirstPageNumber Property
FirstSliceAngle Property
FitToPagesTall Property
FitToPagesWide Property
FixedDecimal Property
FixedDecimalPlaces Property
Floor Property
FolderSuffix Property
Font Property
FontBold Property
FontItalic Property
FontName Property
Fonts Property
FontSize Property
FontStyle Property
FooterMargin Property
ForeColor Property
FormatConditions Property
FormControlType Property
Formula Property
Formula1 Property
Formula2 Property
FormulaArray Property
FormulaHidden Property
FormulaLabel Property
FormulaLocal Property
FormulaR1C1 Property
FormulaR1C1Local Property
Forward Property
FreezePanes Property
FullName Property
FullNameURLEncoded Property
Function Property
G
Gap Property
GapDepth Property
GapWidth Property
GenerateGetPivotData Property
GermanPostReform Property
GradientColorType Property
GradientDegree Property
GradientStyle Property
GradientVariant Property
GrandTotalName Property
GridlineColor Property
GridlineColorIndex Property
GroupItems Property
GroupLevel Property
H
Has3DEffect Property
Has3DShading Property
HasArray Property
HasAutoFormat Property
HasAxis Property
HasBorderHorizontal Property
HasBorderOutline Property
HasBorderVertical Property
HasDataLabel Property
HasDataLabels Property
HasDataTable Property
HasDiagram Property
HasDiagramNode Property
HasDisplayUnitLabel Property
HasDropLines Property
HasErrorBars Property
HasFormula Property
HasHiLoLines Property
HasLeaderLines Property
HasLegend Property
HasMajorGridlines Property
HasMemberProperties Property
HasMinorGridlines Property
HasPassword Property
HasPivotFields Property
HasRadarAxisLabels Property
HasRoutingSlip Property
HasSeriesLines Property
HasTitle Property
HasUpDownBars Property
HeaderMargin Property
HeaderRowRange Property
HeartbeatInterval Property
HebrewModes Property
Height Property
HeightPercent Property
Hidden Property
HiddenFields Property
HiddenItems Property
HiddenItemsList Property
HighlightChangesOnScreen Property
HiLoLines Property
Hinstance Property
HorizontalAlignment Property
HorizontalFlip Property
HPageBreaks Property
HTMLProject Property
HtmlType Property
Hwnd Property
Hyperlink Property
Hyperlinks Property
I
ID Property
Ignore Property
IgnoreBlank Property
IgnoreCaps Property
IgnoreFileNames Property
IgnoreMixedDigits Property
IgnoreRemoteRequests Property
IMEMode Property
InactiveListBorderVisible Property
InCellDropdown Property
IncludeAlignment Property
IncludeBorder Property
IncludeFont Property
IncludeNumber Property
IncludePatterns Property
IncludeProtection Property
InconsistentFormula Property
IndentLevel Property
Index Property
IndicatorColorIndex Property
InnerDetail Property
InputMessage Property
InputTitle Property
InsertRowRange Property
InsideHeight Property
InsideLeft Property
InsideTop Property
InsideWidth Property
Installed Property
Interactive Property
Intercept Property
InterceptIsAuto Property
Interior Property
International Property
InvalidData Property
InvertIfNegative Property
IsAddin Property
IsCalculated Property
IsConnected Property
IsExportable Property
IsInplace Property
IsMemberProperty Property
IsPercent Property
IsValid Property
Italic Property
Item Property
Iteration Property
K
KeepChangeHistory Property
KernedPairs Property
KoreanCombineAux Property
KoreanProcessCompound Property
KoreanUseAutoChangeList Property
L
LabelRange Property
LanguageSettings Property
LargeChange Property
LastChild Property
Layout Property
LayoutBlankLine Property
LayoutForm Property
LayoutPageBreak Property
LayoutSubtotalLocation Property
lcid Property
LeaderLines Property
Left Property
LeftFooter Property
LeftFooterPicture Property
LeftHeader Property
LeftHeaderPicture Property
LeftMargin Property
Legend Property
LegendKey Property
Length Property
LibraryPath Property
Line Property
Line3DGroup Property
LineStyle Property
LinkedCell Property
LinkFormat Property
ListChangesOnNewSheet Property
ListColumns Property
ListCount Property
ListDataFormat Property
ListDataValidation Property
ListFillRange Property
ListHeaderRows Property
ListIndex Property
ListObject Property
ListObjects Property
ListRows Property
ListSelection Property
LoadPictures Property
LocalConnection Property
Location Property
LocationInTable Property
LocationOfComponents Property
LockAspectRatio Property
Locked Property
LockedText Property
M
MacroType Property
MailEnvelope Property
Mailer Property
MailSession Property
MailSystem Property
MaintainConnection Property
MajorGridlines Property
MajorTickMark Property
MajorUnit Property
MajorUnitIsAuto Property
MajorUnitScale Property
ManualUpdate Property
Map Property
MapPaperSize Property
MarginBottom Property
MarginLeft Property
MarginRight Property
MarginTop Property
MarkerBackgroundColor Property
MarkerBackgroundColorIndex Property
MarkerForegroundColor Property
MarkerForegroundColorIndex Property
MarkerSize Property
MarkerStyle Property
MathCoprocessorAvailable Property
Max Property
MaxChange Property
MaxCharacters Property
Maximum Property
MaximumScale Property
MaximumScaleIsAuto Property
MaxIterations Property
MaxNumber Property
MDX Property
MemoryFree Property
MemoryUsed Property
MergeArea Property
MergeCells Property
MergeLabels Property
Message Property
Min Property
MinimumScale Property
MinimumScaleIsAuto Property
MinNumber Property
MinorGridlines Property
MinorTickMark Property
MinorUnit Property
MinorUnitIsAuto Property
MinorUnitScale Property
MissingItemsLimit Property
MouseAvailable Property
MoveAfterReturn Property
MoveAfterReturnDirection Property
MultiSelect Property
MultiUserEditing Property
N
Name Property
NameIsAuto Property
NameLocal Property
Names Property
Namespace Property
Native Property
NetworkTemplatesPath Property
NewWorkbook Property
Next Property
Nodes Property
NormalizedHeight Property
NullString Property
Number Property
NumberAsText Property
NumberFormat Property
NumberFormatLinked Property
NumberFormatLocal Property
O
Object Property
Obscured Property
ODBCErrors Property
ODBCTimeout Property
Offset Property
OffsetX Property
OffsetY Property
OLAP Property
OLEDBErrors Property
OLEFormat Property
OLEType Property
OmittedCells Property
On Property
OnAction Property
OnWindow Property
OperatingSystem Property
Operator Property
OptimizeCache Property
Order Property
OrganizationName Property
OrganizeInFolder Property
Orientation Property
Outline Property
OutlineFont Property
OutlineLevel Property
Overlap Property
P
PageBreak Property
PageFieldOrder Property
PageFields Property
PageFieldStyle Property
PageFieldWrapCount Property
PageRange Property
PageRangeCells Property
PageSetup Property
Panes Property
PaperSize Property
Parameters Property
Parent Property
ParentField Property
ParentGroup Property
ParentItem Property
ParentItems Property
ParentShowDetail Property
Password Property
PasswordEncryptionAlgorithm Property
PasswordEncryptionFileProperties Property
PasswordEncryptionKeyLength Property
PasswordEncryptionProvider Property
Path Property
PathSeparator Property
Pattern Property
PatternColor Property
PatternColorIndex Property
Period Property
Permission Property
PersonalViewListSettings Property
PersonalViewPrintSettings Property
Perspective Property
Phonetic Property
PhoneticCharacters Property
Phonetics Property
PictureFormat Property
PictureType Property
PictureUnit Property
Pie3DGroup Property
PivotCell Property
PivotCellType Property
PivotField Property
PivotFields Property
PivotFormulas Property
PivotItem Property
PivotLayout Property
PivotSelection Property
PivotSelectionStandard Property
PivotTable Property
PivotTableSelection Property
PixelsPerInch Property
Placement Property
PlotArea Property
PlotBy Property
PlotOrder Property
PlotVisibleOnly Property
Points Property
Position Property
PostText Property
Precedents Property
PrecisionAsDisplayed Property
Prefix Property
PrefixCharacter Property
PresentInPane Property
PreserveColumnFilter Property
PreserveColumnInfo Property
PreserveFormatting Property
PreserveNumberFormatting Property
PresetExtrusionDirection Property
PresetGradientType Property
PresetLightingDirection Property
PresetLightingSoftness Property
PresetMaterial Property
PresetShape Property
PresetTextEffect Property
PresetTexture Property
PresetThreeDFormat Property
Previous Property
PreviousSelections Property
PrintArea Property
PrintComments Property
PrintErrors Property
PrintGridlines Property
PrintHeadings Property
PrintNotes Property
PrintObject Property
PrintQuality Property
PrintSettings Property
PrintTitleColumns Property
PrintTitleRows Property
PrintTitles Property
ProductCode Property
progID Property
PromptForSummaryInfo Property
PromptString Property
Properties Property
PropertyOrder Property
PropertyParentField Property
ProtectChartObject Property
ProtectContents Property
ProtectData Property
ProtectDrawingObjects Property
ProtectFormatting Property
ProtectGoalSeek Property
Protection Property
ProtectionMode Property
ProtectScenarios Property
ProtectSelection Property
ProtectStructure Property
ProtectWindows Property
PublishObjects Property
Q
QueryTable Property
QueryTables Property
QueryType Property
R
RadarAxisLabels Property
RadioGroupSelection Property
Range Property
RangeSelection Property
ReadingOrder Property
ReadOnly Property
ReadOnlyRecommended Property
Ready Property
Received Property
RecentFiles Property
Recipients Property
Recognize Property
RecordCount Property
RecordRelative Property
Recordset Property
ReferenceStyle Property
RefersTo Property
RefersToLocal Property
RefersToR1C1 Property
RefersToR1C1Local Property
RefersToRange Property
RefreshDate Property
Refreshing Property
RefreshName Property
RefreshOnChange Property
RefreshOnFileOpen Property
RefreshPeriod Property
RefreshStyle Property
RegisteredFunctions Property
RelyOnCSS Property
RelyOnVML Property
RemovePersonalInformation Property
Repeating Property
RepeatItemsOnEachPrintedPage Property
ReplaceFormat Property
ReplacementList Property
ReplaceText Property
Required Property
Resize Property
ResultRange Property
ReturnWhenDone Property
Reverse Property
ReversePlotOrder Property
RevisionNumber Property
RGB Property
RightAngleAxes Property
RightFooter Property
RightFooterPicture Property
RightHeader Property
RightHeaderPicture Property
RightMargin Property
RobustConnect Property
RollZoom Property
Root Property
RootElementName Property
RootElementNamespace Property
RotatedChars Property
Rotation Property
RotationX Property
RotationY Property
RoundedCorners Property
Routed Property
RoutingSlip Property
Row Property
RowColSettings Property
RowFields Property
RowGrand Property
RowHeight Property
RowItems Property
RowNumbers Property
RowRange Property
Rows Property
RTD Property
S
Saved Property
SaveData Property
SaveDataSourceDefinition Property
SaveHiddenData Property
SaveLinkValues Property
SaveNewWebPagesAsWebArchives Property
SavePassword Property
ScaleType Property
Schemas Property
SchemeColor Property
ScreenSize Property
ScreenTip Property
ScreenUpdating Property
Script Property
Scripts Property
ScrollArea Property
ScrollColumn Property
ScrollRow Property
SecondaryPlot Property
SecondPlotSize Property
SegmentType Property
SelectedSheets Property
Selection Property
SelectionMode Property
SendDateTime Property
Sender Property
Separator Property
SeriesLines Property
ServerBased Property
Shadow Property
Shape Property
ShapeRange Property
Shapes Property
SharedWorkspace Property
SharePointFormula Property
SharePointURL Property
Sheet Property
Sheets Property
SheetsInNewWorkbook Property
ShortcutKey Property
ShowAllItems Property
ShowAutoFilter Property
ShowBubbleSize Property
ShowCategoryName Property
ShowCellBackgroundFromOLAP Property
ShowChartTipNames Property
ShowChartTipValues Property
ShowConflictHistory Property
ShowDetail Property
ShowError Property
ShowImportExportValidationErrors Property
ShowInFieldList Property
ShowInput Property
ShowLegendKey Property
ShowNegativeBubbles Property
ShowPageMultipleItemLabel Property
ShowPercentage Property
ShowPivotTableFieldList Property
ShowSeriesName Property
ShowStartupDialog Property
ShowToolTips Property
ShowTotals Property
ShowValue Property
ShowWindow Property
ShowWindowsInTaskbar Property
ShrinkToFit Property
Size Property
SizeRepresents Property
SizeWithWindow Property
SmallChange Property
SmallGrid Property
SmartDocument Property
SmartTagActions Property
SmartTagOptions Property
SmartTagRecognizers Property
SmartTags Property
Smooth Property
SolveOrder Property
SoundNote Property
Source Property
SourceConnectionFile Property
SourceData Property
SourceDataFile Property
SourceName Property
SourceNameStandard Property
SourceRange Property
SourceType Property
SourceUrl Property
SpeakCellOnEnter Property
Speech Property
SpellingOptions Property
Split Property
SplitColumn Property
SplitHorizontal Property
SplitRow Property
SplitType Property
SplitValue Property
SplitVertical Property
SqlState Property
Stage Property
StandardFont Property
StandardFontSize Property
StandardFormula Property
StandardHeight Property
StandardWidth Property
Start Property
StartupPath Property
Status Property
StatusBar Property
Strikethrough Property
Style Property
Styles Property
SubAddress Property
Subject Property
Subscript Property
SubtotalHiddenPageItems Property
SubtotalName Property
Subtotals Property
SuggestMainOnly Property
Summary Property
SummaryColumn Property
SummaryRow Property
Superscript Property
SurfaceGroup Property
Sync Property
SyncScrollingSideBySide Property
T
Tab Property
TableRange1 Property
TableRange2 Property
TableStyle Property
TabRatio Property
Tag Property
TargetBrowser Property
TemplateRemoveExtData Property
TemplatesPath Property
Text Property
TextboxText Property
TextDate Property
TextEffect Property
TextFileColumnDataTypes Property
TextFileCommaDelimiter Property
TextFileConsecutiveDelimiter Property
TextFileDecimalSeparator Property
TextFileFixedColumnWidths Property
TextFileOtherDelimiter Property
TextFileParseType Property
TextFilePlatform Property
TextFilePromptOnRefresh Property
TextFileSemicolonDelimiter Property
TextFileSpaceDelimiter Property
TextFileStartRow Property
TextFileTabDelimiter Property
TextFileTextQualifier Property
TextFileThousandsSeparator Property
TextFileTrailingMinusNumbers Property
TextFileVisualLayout Property
TextFrame Property
TextShape Property
TextToDisplay Property
TextureName Property
TextureType Property
ThisCell Property
ThisWorkbook Property
ThousandsSeparator Property
ThreeD Property
ThrottleInterval Property
TickLabelPosition Property
TickLabels Property
TickLabelSpacing Property
TickMarkSpacing Property
Time Property
TintAndShade Property
Title Property
Top Property
TopLeftCell Property
TopMargin Property
ToRecipients Property
TotalLevels Property
TotalsAnnotation Property
TotalsCalculation Property
TotalsRowRange Property
Tracking Property
TrackStatus Property
TransitionExpEval Property
TransitionFormEntry Property
TransitionMenuKey Property
TransitionMenuKeyAction Property
TransitionNavigKeys Property
Transparency Property
TransparencyColor Property
TransparentBackground Property
TreeviewControl Property
TwoInitialCapitals Property
Type Property
U
Underline Property
UnlockedFormulaCells Property
UpBars Property
UpdateLinks Property
UpdateLinksOnSave Property
UpdateRemoteReferences Property
Uri Property
UsableHeight Property
UsableWidth Property
UsedObjects Property
UsedRange Property
UseLocalConnection Property
UseLongFileNames Property
UserControl Property
UserDict Property
UserLibraryPath Property
UserName Property
Users Property
UserStatus Property
UseStandardHeight Property
UseStandardWidth Property
UseSystemSeparators Property
V
VacatedStyle Property
Validation Property
Value Property
Value2 Property
Values Property
VaryByCategories Property
VBASigned Property
VBE Property
VBProject Property
Version Property
VerticalAlignment Property
VerticalFlip Property
Vertices Property
View Property
ViewCalculatedMembers Property
Visible Property
VisibleFields Property
VisibleItems Property
VisibleRange Property
VisualTotals Property
VPageBreaks Property
W
Walls Property
WallsAndGridlines2D Property
Watches Property
WebConsecutiveDelimitersAsOne Property
WebDisableDateRecognition Property
WebDisableRedirections Property
WebFormatting Property
WebOptions Property
WebPreFormattedTextToColumns Property
WebSelectionType Property
WebSingleBlockTextImport Property
WebTables Property
Weight Property
WhichAddress Property
Width Property
WindowNumber Property
Windows Property
WindowsForPens Property
WindowState Property
Workbooks Property
Worksheet Property
WorksheetFunction Property
Worksheets Property
WrapText Property
WritePassword Property
WriteReserved Property
WriteReservedBy Property
X
XML Property
XmlMap Property
XmlMaps Property
XmlNamespaces Property
XPath Property
XValues Property
Z
Zoom Property
ZOrder Property
ZOrderPosition Property
Events
A
Activate Event
AddinInstall Event
AddinUninstall Event
AfterRefresh Event
AfterXmlExport Event
AfterXmlImport Event
B
BeforeClose Event
BeforeDoubleClick Event
BeforePrint Event
BeforeRefresh Event
BeforeRightClick Event
BeforeSave Event
BeforeXmlExport Event
BeforeXmlImport Event
C
Calculate Event
Change Event
D
Deactivate Event
DragOver Event
DragPlot Event
F
FollowHyperlink Event
G
GotFocus Event
L
LostFocus Event
M
MouseDown Event
MouseMove Event
MouseUp Event
N
NewSheet Event
NewWorkbook Event
O
Open Event
P
PivotTableCloseConnection Event
PivotTableOpenConnection Event
PivotTableUpdate Event
R
Resize Event
S
Select Event
SelectionChange Event
SeriesChange Event
SheetActivate Event
SheetBeforeDoubleClick Event
SheetBeforeRightClick Event
SheetCalculate Event
SheetChange Event
SheetDeactivate Event
SheetFollowHyperlink Event
SheetPivotTableUpdate Event
SheetSelectionChange Event
Sync Event
W
WindowActivate Event
WindowDeactivate Event
WindowResize Event
WorkbookActivate Event
WorkbookAddinInstall Event
WorkbookAddinUninstall Event
WorkbookAfterXmlExport Event
WorkbookAfterXmlImport Event
WorkbookBeforeClose Event
WorkbookBeforePrint Event
WorkbookBeforeSave Event
WorkbookBeforeXmlExport Event
WorkbookBeforeXmlImport Event
WorkbookDeactivate Event
WorkbookNewSheet Event
WorkbookOpen Event
WorkbookPivotTableCloseConnection Event
WorkbookPivotTableOpenConnection Event
WorkbookSync Event
Enumerations
Microsoft Excel Constants
Get in touch
Submit feedback about this site to:
[email protected]