Classes | Properties | Methods |
<Globals> | ActiveCell ActiveChart ActiveSheet ActiveWindow ActiveWorkbook Application Cells Charts Columns Names Parent Range
Rows
Selection Sheets ThisWorkbook Windows Workbooks WorksheetFunction
Worksheets
|
|
Application | ActiveCell ActiveSheet ActiveWindow ActiveWorkbook Application Cells Columns DisplayAlerts EnableEvents Names Parent Range Rows ScreenUpdating Selection Sheets ThisWorkbook Windows Workbooks
WorksheetFunction
Worksheets
| Calculate CalculateFull CentimetersToPoints InchesToPoints Intersect
Union
|
Areas | |
- Item
|
|
Axis | Application AxisTitle HasTitle
Parent
| No supported methods for this class |
AxisTitle | Application Caption Parent
Text
|
- Delete
|
|
Border | Application Color LineStyle Parent
Weight
|
No supported methods for this class
|
|
Borders | Application Color ColorIndex Count LineStyle Parent Value
Weight
|
- Item
|
|
Characters | | No supported methods for this class |
Chart | Application ChartTitle ChartType HasLegend HasTitle
Parent
| ApplyDataLabels Axes Delete Refresh
SetSourceData
|
ChartObject | Application Chart Height Left Name Parent Top
Width
| |
ChartObjects | Application Count Height Left Parent Top
Width
| |
ChartTitle | Application Caption Parent
Text
|
- Delete
|
|
ColorScale | ColorScaleObject AppliesTo ColorScaleCriteria Index Type Value FormatColor Color
ColorIndex
| No supported methods for this class |
Comment | | |
Comments | |
- Item
|
|
FormatCondition | Font Borders Interior Color ColorIndex Creator FontStyle Italic Strikethrough
Underline
Bold Item Name Size LineStyle
Weight
| No supported methods for this class |
Font | Application Bold Color ColorIndex FontStyle Italic Name Parent Size Strikethrough
Underline
| No supported methods for this class |
Hyperlink | Address Application Name Parent Range
TextToDisplay
|
- Delete
|
|
Hyperlinks | | |
Interior | Application Parent Color
ColorIndex
| No supported methods for this class |
Name | Application Name Parent RefersTo RefersToR1C1
RefersToRange
|
- Delete
|
|
Names | | |
Range | Address Application Areas Borders Cells Column Columns Comment ColumnWidth CurrentRegion Dependents DirectDependents DirectPrecedents End EntireColumn EntireRow
Font
Formula FormulaArray FormulaR1C1 HasFormula HorizontalAlignment Hyperlinks Interior Item Locked MergeCells MergeArea Name NumberFormat Offset Parent Precedents Range Resize Row Rows RowHeight Text Value Value2 VerticalAlignment WorkSheet
WrapText
| Activate AddComment AutoFill AutoFilter AutoFit BorderAround Calculate Clear ClearComments ClearContents ClearFormats ClearNotes Copy Cut DataSeries Delete FillDown FillLeft FillRight FillUp Insert Merge Select UnMerge Sort
SpecialCells
|
RoutingSlip | Application Delivery Message Parent Recipients Status
Subject
|
- Reset
|
|
Sheets | | |
Window | ActiveCell ActiveSheet Application Caption Parent RangeSelection
Selection
| No supported methods for this class |
Windows | |
- Item
|
|
Workbook | ActiveSheet Application HasRoutingSlip Name Names Parent Routed RoutingSlip Sheets Windows
Worksheets
| Route Save SaveAs SaveCopyAs SendMail
|
Worksheet | Application Cells Columns Comments Hyperlinks Index Name Names Parent Range Rows
UsedRange
| Activate Calculate ChartObjects Copy Delete Move Select
Paste
|
WorksheetFunction | | Acos Acosh And Asin Asinh Atan2 Atanh Average Bin2Dec Bin2Hex Bin2Oct Ceiling Choose Clean Combin Convert Count CountA CountBlank CountIf Days360 Dec2Bin Dec2Hex Dec2Oct Degrees Dollar Even EDate EoMonth Fact Find Fixed Floor Gcd Hex2Dec Hex2Oct Hex2Bin HLookup Index IsEven IsErr IsError
IsLogical
IsNA IsNonText IsNumber IsOdd IsText Large Lcm Ln Log Log10 Lookup Match Max Min MRound MultiNomial NetworkDays Oct2Hex Oct2Bin Oct2Hex Odd Or Pi Power Product Proper Quotient Radians
RandBetween
Replace Rept Roman Round RoundDown RoundUp Search SeriesSum Small StDev StDevP Substitute SubTotal Sum SumIf SumSq Tanh Text Trim Var VarP VLookup WeekDay WeekNum WorkDay
YearFrac
|
Worksheets | | Add FillAcrossSheets
​Item
|