_IQueryTable Interface _OLEObject Interface _QueryTable Interface _Workbook Interface _Worksheet Interface AboveAverage Interface Action Interface Actions Interface AddIn Interface AddIns Interface AddIns2 Interface Adjustments Interface AllowEditRange Interface ...
Expand table Excel Developer Reference Fills left from the rightmost cell or cells in the specified range. The contents and formatting of the cell or cells in the rightmost column of a range are copied into the rest of the columns in the range. Syntax expression.FillLeft expression A varia...
Expand table NameRequired/OptionalData TypeDescription Range Required Range The range to fill on all the worksheets in the collection. The range must be from a worksheet within the collection. Type Optional XlFillWith Specifies how to copy the range. Example This example fills the range A1:C5...
XlPivotCellType Enumeration XlPivotConditionScope Enumeration XlPivotFieldCalculation Enumeration XlPivotFieldDataType Enumeration XlPivotFieldOrientation Enumeration XlPivotFieldRepeatLabels Enumeration XlPivotFilterType Enumeration XlPivotFormatType Enumeration XlPivotLineType Enumeration XlPivotTableMissingItems Enumera...
XlPivotCellType Enumeration XlPivotConditionScope Enumeration XlPivotFieldCalculation Enumeration XlPivotFieldDataType Enumeration XlPivotFieldOrientation Enumeration XlPivotFieldRepeatLabels Enumeration XlPivotFilterType Enumeration XlPivotFormatType Enumeration XlPivotLineType Enumeration XlPivotTableMissingItems Enumera...
XlPivotCellType Enumeration XlPivotConditionScope Enumeration XlPivotFieldCalculation Enumeration XlPivotFieldDataType Enumeration XlPivotFieldOrientation Enumeration XlPivotFieldRepeatLabels Enumeration XlPivotFilterType Enumeration XlPivotFormatType Enumeration XlPivotLineType Enumeration XlPivotTableMissingItems Enumera...