Range 接口

定义

代表某一单元格、某一行、某一列、某一选定区域(该区域可包含一个或若干连续单元格区域),或者某一三维区域。Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.

public interface class Range : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("00020846-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Range : System.Collections.IEnumerable
Public Interface Range
Implements IEnumerable
属性
实现

属性

_Default[Object, Object]

保留以供内部使用。 Reserved for internal use.

AddIndent

确定当单元格中的文本对齐方式设置为水平或垂直相等分布时文本是否自动缩进。Determines if text is automatically indented when the text alignment in a cell is set to equal distribution either horizontally or vertically.

Address[Object, Object, XlReferenceStyle, Object, Object]

返回区域引用。Returns the range reference.

AddressLocal[Object, Object, XlReferenceStyle, Object, Object]

以用户语言返回对指定区域的区域引用。Returns the range reference for the specified range in the language of the user.

AllowEdit

确定是否可以在受保护的工作表上编辑区域。Determines if the range can be edited on a protected worksheet.

Application

返回 Application 一个代表 Microsoft Excel 应用程序的对象。Returns an Application object that represents the Microsoft Excel application.

Areas

返回 Areas 一个集合,该集合代表多区域选定区域的所有区域。Returns an Areas collection that represents all the ranges in a multiple-area selection.

Borders

返回一个集合,该集合代表样式或单元格区域 (区域定义为条件格式的一 Borders) 。Returns a Borders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).

Cells

返回一个 Range 对象,它表示指定区域中的单元格。Returns a Range object that represents the cells in the specified range.

Characters[Object, Object]

返回 Characters 一个对象,该对象代表对象文本中的字符范围。Returns a Characters object that represents a range of characters within the object text.

Column

返回指定区域中第一块中的第一列的列号。Returns the number of the first column in the first area in the specified range.

Columns

返回 Range 一个对象,该对象代表指定范围中的列。Returns a Range object that represents the columns in the specified range.

ColumnWidth

返回或设置指定区域中所有列的列宽。Returns or sets the width of all columns in the specified range.

Comment

返回 Comment 一个对象,该对象代表与区域左上角的单元格相关联的批注。Returns a Comment object that represents the comment associated with the cell in the upper-left corner of the range.

Count

返回集合中对象的数目。Returns the number of objects in the collection.

CountLarge

计算给定值范围中的最大值。Counts the largest value in a given Range of values. 只读。Read-only.

Creator

返回一个 32 位整数,该整数指示在其中创建了此对象的应用程序。Returns a 32-bit integer that indicates the application in which this object was created.

CurrentArray

如果指定的单元格是数组的一部分,则返回 Range 一个代表整个数组的对象。If the specified cell is part of an array, returns a Range object that represents the entire array.

CurrentRegion

返回 Range 一个对象,该对象代表当前区域。Returns a Range object that represents the current region.

Dependents

返回 Range 一个对象,该对象代表包含单元格的所有从属单元格的范围。Returns a Range object that represents the range containing all the dependents of a cell.

DirectDependents

返回 Range 一个对象,该对象代表包含单元格的所有直接从属单元格的范围。Returns a Range object that represents the range containing all the direct dependents of a cell.

DirectPrecedents

返回 Range 一个对象,该对象代表包含单元格的所有直接引用单元格的范围。Returns a Range object that represents the range containing all the direct precedents of a cell.

DisplayFormat

获取 DisplayFormat 一个对象,该对象代表指定范围的显示设置。Gets a DisplayFormat object that represents the display settings for the specified range.

End[XlDirection]

返回 Range 一个对象,该对象代表包含源区域的区域末尾的单元格。Returns a Range object that represents the cell at the end of the region that contains the source range.

EntireColumn

返回一个对象,该对象代表包含指定 (Range 区域) 列。Returns a Range object that represents the entire column (or columns) that contains the specified range.

EntireRow

返回一 Range 个对象,该对象代表包含指定 (区域) 行的整行。Returns a Range object that represents the entire row (or rows) that contains the specified range.

Errors

允许用户访问错误检查选项。Allows the user to access error checking options.

Font

返回 Font 一个对象,该对象代表指定对象的字体。Returns a Font object that represents the font of the specified object.

FormatConditions

返回 FormatConditions 一个集合,该集合代表指定区域的所有条件格式。Returns a FormatConditions collection that represents all the conditional formats for the specified range.

Formula

返回或设置 A1 样式表示法和宏语言中的对象的公式。Returns or sets the object's formula in A1-style notation and in the language of the macro.

FormulaArray

返回或设置区域的数组公式。Returns or sets the array formula of a range.

FormulaHidden

确定工作表受保护时是否隐藏公式。Determines if the formula will be hidden when the worksheet is protected.

FormulaLabel

返回或设置指定范围的公式标签类型。Returns or sets the formula label type for the specified range.

FormulaLocal

返回或设置对象,在语言中的用户使用 A1-样式引用的公式。Returns or sets the formula for the object, using A1-style references in the language of the user.

FormulaR1C1

使用采用宏语言的 R1C1 表示法,返回或设置对象的公式。Returns or sets the formula for the object, using R1C1-style notation in the language of the macro.

FormulaR1C1Local

返回或设置对象,使用的用户语言的 R1C1 样式表示法表示的公式。Returns or sets the formula for the object, using R1C1-style notation in the language of the user.

HasArray

确定指定的单元格是否属于数组公式。Determines if the specified cell is part of an array formula.

HasFormula

确定区域内的所有单元格是否都包含公式。Determines if all cells in the range contain formulas.

Height

区域的高度。The height of the range.

Hidden

确定是否隐藏行或列。Determines if the rows or columns are hidden.

HorizontalAlignment

返回或设置指定对象的水平对齐方式。Returns or sets the horizontal alignment for the specified object.

Hyperlinks

返回 Hyperlinks 一个集合,该集合代表该范围的超链接。Returns a Hyperlinks collection that represents the hyperlinks for the range.

ID

返回或设置将页面另存为网页时指定单元格的标识标签。Returns or sets the identifying label for the specified cell when the page is saved as a Web page.

IndentLevel

返回或设置单元格或范围的缩进级别。Returns or sets the indent level for the cell or range.

Interior

返回 Interior 一个对象,该对象代表指定对象的内部。Returns an Interior object that represents the interior of the specified object.

Item[Object, Object]

返回一 Range 个对象,该对象代表与指定区域偏移时的范围。Returns a Range object that represents a range at an offset to the specified range.

Left

A 列左边缘到区域左边缘的距离。The distance from the left edge of column A to the left edge of the range.

ListHeaderRows

返回指定区域中标题行的数目。Returns the number of header rows for the specified range.

ListObject

返回 ListObject 对象的对象 Range QueryTableReturns a ListObject object for the Range object or QueryTable object.

LocationInTable

返回一个常量,该常量描述包含指定区域左上角 PivotTable 的报表部分。Returns a constant that describes the part of the PivotTable report that contains the upper-left corner of the specified range.

Locked

确定对象是否锁定。Determines if the object is locked.

MDX

返回指定对象的 MDX Range 名称。Returns the MDX name for the specified Range object. 只读。Read-only.

MergeArea

返回 Range 一个对象,该对象代表包含指定单元格的合并区域。Returns a Range object that represents the merged range containing the specified cell.

MergeCells

确定区域或样式是否包含合并单元格。Determines if the range or style contains merged cells.

Name

返回或设置对象的名称。Returns or sets the name of the object.

Next

返回一 Range 个对象,该对象代表下一个单元格。Returns a Range object that represents the next cell.

NumberFormat

返回或设置对象的格式代码。Returns or sets the format code for the object.

NumberFormatLocal

返回或设置对象的格式代码,以用户的语言的字符串形式。Returns or sets the format code for the object as a string in the language of the user.

Offset[Object, Object]

返回 Range 一个对象,该对象代表与指定区域偏移的范围。Returns a Range object that represents a range that’s offset from the specified range.

Orientation

返回文本方向。Returns the text orientation.

OutlineLevel

返回或设置指定行或列的当前分级显示级别。Returns or sets the current outline level of the specified row or column.

PageBreak

获取或设置分页符的位置。Returns or sets the location of a page break.

Parent

返回指定对象的父对象。Returns the parent object for the specified object.

Phonetic

返回 Phonetic 包含有关单元格中特定音节文本字符串的信息的对象。Returns the Phonetic object which contains information about a specific phonetic text string in a cell.

Phonetics

返回 Phonetics 区域的集合。Returns the Phonetics collection of the range.

PivotCell

返回一 PivotCell 个对象,该对象代表数据透视表中的单元格。Returns a PivotCell object that represents a cell in a PivotTable report.

PivotField

返回一个对象,该对象代表包含指定区域左上角的数据透视表 PivotField 字段。Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range.

PivotItem

返回一个对象,该对象代表包含指定区域左上角的数据透视 PivotItem 表项。Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range.

PivotTable

返回一个对象,该对象代表包含指定区域左上角的数据透视表或与数据透视图报表 PivotTable 关联的数据透视表。Returns a PivotTable object that represents the PivotTable report containing the upper-left corner of the specified range, or the PivotTable report associated with the PivotChart report.

Precedents

返回 Range 一个对象,该对象代表单元格的所有引用单元格。Returns a Range object that represents all the precedents of a cell.

PrefixCharacter

返回单元格的前缀字符。Returns the prefix character for the cell.

Previous

返回一 Range 个对象,该对象代表上一个单元格。Returns a Range object that represents the previous cell.

QueryTable

返回 QueryTable 一个对象,该对象代表与指定对象相交的查询 Range 表。Returns a QueryTable object that represents the query table that intersects the specified Range object.

Range[Object, Object]

返回 Range 一个对象,该对象代表单元格或单元格区域。Returns a Range object that represents a cell or a range of cells.

ReadingOrder

返回或设置指定对象的阅读次序。Returns or sets the reading order for the specified object.

Resize[Object, Object]

调整指定区域的大小。Resizes the specified range.

Row

返回区域中第一个区域的第一行的行号。Returns the number of the first row of the first area in the range.

RowHeight

以磅为单位返回或设置指定区域中所有行的行高。Returns the height of all the rows in the range specified, measured in points.

Rows

返回 Range 一个对象,该对象代表指定范围中的行。Returns a Range object that represents the rows in the specified range.

ServerActions

指定可在 SharePoint 服务器上为对象执行的操作 RangeSpecifies the actions that can be performed on the SharePoint server for a Range object.

ShowDetail

如果 指定区域扩展边框,则返回 True (以便列或行的详细信息显示在) 。Returns True if the outline is expanded for the specified range (so that the detail of the column or row is visible).

ShrinkToFit

确定文本是否自动缩小以适应可用列宽。Determines if text automatically shrinks to fit in the available column width.

SmartTags

返回 SmartTags 一个对象,该对象代表指定单元格的标识符。Returns a SmartTags object representing the identifier for the specified cell.

SoundNote

本属性不应再被使用。This property should not be used. 语音批注已从 Microsoft Excel 中删除。Sound notes have been removed from Microsoft Excel.

SparklineGroups

获取 SparklineGroups 一个对象,该对象代表指定区域的现有迷你图组。Gets a SparklineGroups object that represents an existing group of sparklines from the specified range.

Style

返回 Style 一个对象,该对象代表指定范围的样式。Returns a Style object that represents the style of the specified range.

Summary

确定区域是大纲摘要行还是列。Determines if the range is an outlining summary row or column.

Text

返回或设置指定对象中的文本。Returns or sets the text for the specified object.

Top

返回从第 1 行的上边缘到区域上边缘的距离(以点表示)。Returns the distance, in points, from the top edge of row 1 to the top edge of the range.

UseStandardHeight

确定对象的行高 Range 是否等于工作表的标准高度。Determines if the row height of the Range object equals the standard height of the sheet.

UseStandardWidth

确定对象的列宽 Range 是否等于工作表的标准宽度。Determines if the column width of the Range object equals the standard width of the sheet.

Validation

返回 Validation 表示指定区域的数据有效性的对象。Returns the Validation object that represents data validation for the specified range.

Value[Object]

返回或设置指定区域的值。Returns or sets the value of the specified range.

Value2

返回或设置单元格值。Returns or sets the cell value.

VerticalAlignment

返回或设置指定对象的垂直对齐方式。Returns or sets the vertical alignment of the specified object.

Width

范围的宽度(以点表示)。The width, in points, of the range.

Worksheet

返回 Worksheet 一个对象,该对象代表包含指定范围的工作表。Returns a Worksheet object that represents the worksheet containing the specified range.

WrapText

确定 Microsoft Excel 是否将对象中的文本换行。Determines if Microsoft Excel wraps the text in the object.

XPath

返回 XPath 一个对象,该对象代表映射到指定对象的元素的 Range Xpath。Returns an XPath object that represents the Xpath of the element mapped to the specified Range object.

方法

_PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object)

保留以供内部使用。Reserved for internal use.

_PrintOut(Object, Object, Object, Object, Object, Object, Object)

保留以供内部使用。Reserved for internal use.

Activate()

激活单个单元格,该单元格必须处于当前选定区域内。Activates a single cell, which must be inside the current selection.

AddComment(Object)

为区域添加批注。Adds a comment to the range.

AdvancedFilter(XlFilterAction, Object, Object, Object)

基于条件区域从列表中筛选或复制数据。Filters or copies data from a list based on a criteria range.

AllocateChanges()

为基于 OLAP 数据源的区域中的所有已编辑单元格执行写回操作。Performs a writeback operation for all edited cells in a range based on an OLAP data source.

ApplyNames(Object, Object, Object, Object, Object, XlApplyNamesOrder, Object)

将名称应用于指定区域中的单元格。Applies names to the cells in the specified range.

ApplyOutlineStyles()

对指定区域应用分级显示样式。Applies outlining styles to the specified range.

AutoComplete(String)

从列表中返回一个记忆式键入匹配项。Returns an AutoComplete match from the list.

AutoFill(Range, XlAutoFillType)

对指定区域中的单元格执行自动填充。Performs an autofill on the cells in the specified range.

AutoFilter(Object, Object, XlAutoFilterOperator, Object, Object)

使用“自动筛选”筛选一个列表。Filters a list using the AutoFilter.

AutoFit()

更改区域中的列宽或行高以达到最佳匹配。Changes the width of the columns in the range or the height of the rows in the range to achieve the best fit.

AutoFormat(XlRangeAutoFormat, Object, Object, Object, Object, Object, Object)

使用预定义的格式自动设置指定区域的格式。Automatically formats the specified range, using a predefined format.

AutoOutline()

自动为指定区域创建分级显示。Automatically creates an outline for the specified range.

BorderAround(Object, XlBorderWeight, XlColorIndex, Object)

向区域添加边框,并设置新边框的 Color LineStyleWeight 和属性。Adds a border to a range and sets the Color, LineStyle, and Weight properties for the new border.

BorderAround2(Object, XlBorderWeight, XlColorIndex, Object, Object)

仅供内部使用。Reserved for internal use.

Calculate()

计算工作表上的指定单元格区域。Calculates a specified range of cells on a worksheet.

CalculateRowMajorOrder()

计算指定的单元格区域。Calculates a specfied range of cells.

CheckSpelling(Object, Object, Object, Object)

检查对象的拼写。Checks the spelling of an object.

Clear()

清除整个对象。Clears the entire object.

ClearComments()

清除指定区域的所有单元格批注。Clears all cell comments from the specified range.

ClearContents()

清除区域中的公式。Clears the formulas from the range.

ClearFormats()

清除对象的格式设置。Clears the formatting of the object.

ClearHyperlinks()

删除指定区域中的所有超链接。Removes all hyperlinks from the specified range.

ClearNotes()

清除指定区域中所有单元格的批注和语音批注。Clears notes and sound notes from all the cells in the specified range.

ClearOutline()

清除指定区域的分级显示。Clears the outline for the specified range.

ColumnDifferences(Object)

返回 Range 一个对象,该对象代表其内容不同于每列中比较单元格的所有单元格。Returns a Range object that represents all the cells whose contents are different from the comparison cell in each column.

Consolidate(Object, Object, Object, Object, Object)

将多个工作表中多个区域的数据合并计算至单个工作表上的单个区域。Consolidates data from multiple ranges on multiple worksheets into a single range on a single worksheet.

Copy(Object)

将区域复制到指定的区域或剪贴板。Copies the range to the specified range or to the Clipboard.

CopyFromRecordset(Object, Object, Object)

从指定范围的左上角开始,将 ADO 或 DAO Recordset 对象的内容复制到工作表中。Copies the contents of an ADO or DAO Recordset object onto a worksheet, beginning at the upper-left corner of the specified range.

CopyPicture(XlPictureAppearance, XlCopyPictureFormat)

将所选对象作为图片复制到剪贴板。Copies the selected object to the Clipboard as a picture.

CreateNames(Object, Object, Object, Object)

在指定区域中依据工作表中的文本标签创建名称。Creates names in the specified range, based on text labels in the sheet.

CreatePublisher(Object, XlPictureAppearance, Object, Object, Object, Object)

您请求了仅用于 Macintosh 的关键字的帮助。You have requested Help for a keyword used only on the Macintosh. 有关该关键词的帮助信息,请查阅 Microsoft Office Macintosh 版的语言参考帮助。For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.

Cut(Object)

将对象剪切到剪贴板,或者将其粘贴到指定的目的地。Cuts the object to the Clipboard or pastes it into a specified destination.

DataSeries(Object, XlDataSeriesType, XlDataSeriesDate, Object, Object, Object)

在指定区域内创建数据系列。Creates a data series in the specified range.

Delete(Object)

删除对象。Deletes the object.

DialogBox()

显示由 Microsoft Excel 4.0 宏工作表上的对话框定义表所定义的对话框。Displays a dialog box defined by a dialog box definition table on a Microsoft Excel 4.0 macro sheet.

Dirty()

下一次重新计算发生时指定要重新计算的区域。Designates a range to be recalculated when the next recalculation occurs.

DiscardChanges()

放弃区域中经过编辑的单元格中的所有更改。Discards all changes in the edited cells of the range.

EditionOptions(XlEditionType, XlEditionOptionsOption, Object, Object, XlPictureAppearance, XlPictureAppearance, Object)

您请求了仅用于 Macintosh 的关键字的帮助。You have requested Help for a keyword used only on the Macintosh. 有关该关键词的帮助信息,请查阅 Microsoft Office Macintosh 版的语言参考帮助。For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.

ExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)

导出为指定格式的文件。Exports to a file of the specified format.

FillDown()

从指定区域的顶部单元格开始向下填充,直至该区域的底部。Fills down from the top cell or cells in the specified range to the bottom of the range.

FillLeft()

从指定区域的最右边单元格开始向左填充。Fills left from the rightmost cell or cells in the specified range.

FillRight()

从指定区域的最左边单元格开始向右填充。Fills right from the leftmost cell or cells in the specified range.

FillUp()

从指定区域的底部单元格开始向上填充,直至该区域的顶部。Fills up from the bottom cell or cells in the specified range to the top of the range.

Find(Object, Object, Object, Object, Object, XlSearchDirection, Object, Object, Object)

在范围中查找特定信息并返回一个对象,该对象代表找到该信息的第 Range 一个单元格。Finds specific information in a range and returns a Range object that represents the first cell where that information is found.

FindNext(Object)

继续从该方法开始 Find(Object, Object, Object, Object, Object, XlSearchDirection, Object, Object, Object) 搜索。Continues a search that was begun with the Find(Object, Object, Object, Object, Object, XlSearchDirection, Object, Object, Object) method.

FindPrevious(Object)

继续从该方法开始 Find(Object, Object, Object, Object, Object, XlSearchDirection, Object, Object, Object) 搜索。Continues a search that was begun with the Find(Object, Object, Object, Object, Object, XlSearchDirection, Object, Object, Object) method.

FlashFill()

TRUE 表示 Excel 快速填充功能已启用且处于活动状态。TRUE indicates that the Excel Flash Fill feature has been enabled and active.

FunctionWizard()

对指定区域左上角单元格启动“函数向导”。Starts the Function Wizard for the upper-left cell of the range.

GetEnumerator()
GoalSeek(Object, Range)

为得出特定结果而进行单变量求解。Calculates the values necessary to achieve a specific goal.

Group(Object, Object, Object, Object)

当对象代表数据透视表字段的数据范围中的单个单元格时,Group 方法在该字段中执行数值或 Range 基于日期的分组。 When the Range object represents a single cell in a PivotTable field’s data range, the Group method performs numeric or date-based grouping in that field.

Insert(Object, Object)

在工作表或宏表中插入一个单元格或单元格区域,其他单元格相应移位以腾出空间。Inserts a cell or a range of cells into the worksheet or macro sheet and shifts other cells away to make space.

InsertIndent(Int32)

向指定的区域添加缩进量。Adds an indent to the specified range.

Justify()

调整区域内的文字,使之均衡地填充该区域。Rearranges the text in a range so that it fills the range evenly.

ListNames()

从区域的第一个单元格开始,将所有显示的名称的列表粘贴到工作表上。Pastes a list of all displayed names onto the worksheet, beginning with the first cell in the range.

Merge(Object)

从指定对象创建合并 Range 的单元格。Creates a merged cell from the specified Range object.

NavigateArrow(Object, Object, Object)

定位追踪箭头,此箭头指定引用单元格、从属单元格或错误源单元格。Navigates a tracer arrow for the specified range to the precedent, dependent, or error-causing cell or cells.

NoteText(Object, Object, Object)

返回或设置与区域左上角单元格相关联的单元格注释。Returns or sets the cell note associated with the cell in the upper-left corner of the range.

Parse(Object, Object)

分列区域内的数据并将这些数据分散放置于若干单元格中。Parses a range of data and breaks it into multiple cells.

PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object)

将剪 Range 贴板中的一个粘贴到指定区域。Pastes a Range from the Clipboard into the specified range.

PrintOut(Object, Object, Object, Object, Object, Object, Object, Object)

打印对象。Prints the object.

PrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object)

仅供内部使用。Reserved for internal use.

PrintPreview(Object)

按对象打印后的外观效果显示对象的预览。Shows a preview of the object as it would look when printed.

RemoveDuplicates(Object, XlYesNoGuess)

从值区域中删除重复的值。Removes duplicate values from a range of values.

RemoveSubtotal()

删除列表中的分类汇总。Removes subtotals from a list.

Replace(Object, Object, Object, Object, Object, Object, Object, Object)

返回 Boolean,它表示指定区域内单元格中的字符。Returns a Boolean indicating characters in cells within the specified range.

RowDifferences(Object)

返回一个对象,该对象代表其内容与每行中比较单元格的内容 Range 不同的所有单元格。Returns a Range object that represents all the cells whose contents are different from those of the comparison cell in each row.

Run(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

在该处运行 Microsoft Excel 宏。Runs the Microsoft Excel macro at this location.

Select()

选择对象。Selects the object.

SetPhonetic()

Phonetic 指定区域的所有单元格创建对象。Creates Phonetic objects for all the cells in the specified range.

Show()

滚动当前活动窗口中的内容以将指定区域移到视图中。Scrolls through the contents of the active window to move the range into view.

ShowDependents(Object)

绘制从指定区域指向直接从属单元格的追踪箭头。Draws tracer arrows to the direct dependents of the range.

ShowErrors()

绘制从引用树到作为错误源的单元格的追踪箭头,并返回包含该单元格的范围。Draws tracer arrows through the precedents tree to the cell that’s the source of the error and returns the range that contains that cell.

ShowPrecedents(Object)

绘制从指定区域指向直接引用单元格的追踪箭头。Draws tracer arrows to the direct precedents of the range.

Sort(Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortMethod, XlSortDataOption, XlSortDataOption, XlSortDataOption)

如果指定区域仅包含一个单元格,则对数据透视表、区域或活动区域进行排序。Sorts a PivotTable report, a range, or the active region if the specified range contains only one cell.

SortSpecial(XlSortMethod, Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortDataOption, XlSortDataOption, XlSortDataOption)

使用东亚排序方法对区域或数据透视表进行排序,或者如果该区域仅包含一个单元格,则对活动区域使用该方法。Uses East Asian sorting methods to sort the range or a PivotTable report, or uses the method for the active region if the range contains only one cell. 例如,日文排序方法是按照假名音节表进行排序的。For example, Japanese sorts in the order of the Kana syllabary.

Speak(Object, Object)

按行或列的顺序朗读单元格区域。Causes the cells of the range to be spoken in row order or column order.

SpecialCells(XlCellType, Object)

返回 Range 一个对象,该对象代表与指定类型和值匹配的所有单元格。Returns a Range object that represents all the cells that match the specified type and value.

SubscribeTo(String, XlSubscribeToFormat)

您请求了仅用于 Macintosh 的关键字的帮助。You have requested Help for a keyword used only on the Macintosh. 有关该关键词的帮助信息,请查阅 Microsoft Office Macintosh 版的语言参考帮助。For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.

Subtotal(Int32, XlConsolidationFunction, Object, Object, Object, XlSummaryRow)

创建指定区域或当前区域(如果该区域为单个单元格时)的分类汇总。Creates subtotals for the range (or the current region, if the range is a single cell).

Table(Object, Object)

依据输入值和工作表上定义的公式创建模拟运算表。Creates a data table based on input values and formulas that you define on a worksheet.

TextToColumns(Object, XlTextParsingType, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

将包含文本的一列单元格分解为若干列。Parses a column of cells that contain text into several columns.

Ungroup()

在分级显示中对一个区域进行升级(即降低其分级显示的级别)。Promotes a range in an outline (that is, decreases its outline level).

UnMerge()

将合并区域分解为独立的单元格。Separates a merged area into individual cells.

适用于