Export (0) Print
Expand All
Expand Minimize

NamedRange Methods

The NamedRange type exposes the following members.

  Name Description
Public method _PasteSpecial Infrastructure.
Public method _PrintOut Infrastructure.
Public method Activate Activates a single-cell NamedRange control.
Public method AddComment Adds a comment to the NamedRange control.
Public method AdvancedFilter Filters or copies data from a list based on a criteria range.
Public method AllocateChanges Performs a writeback operation for all edited cells in a named range based on an OLAP data source.
Public method ApplyNames Applies names to the cells in the NamedRange control.
Public method ApplyOutlineStyles Applies outlining styles to the NamedRange control.
Public method AutoComplete Gets an AutoComplete match from the list.
Public method AutoFill Automatically fills the cells in the NamedRange control.
Public method AutoFilter Filters a list using the AutoFilter.
Public method AutoFit Changes the width of the columns or the height of the rows in the NamedRange control to achieve the best fit.
Public method AutoFormat Automatically formats the NamedRange control, using a predefined format.
Public method AutoOutline Automatically creates an outline for the NamedRange control.
Public method BeginInit Signals the object that initialization is starting. (Inherited from ISupportInitialize.)
Public method BorderAround Adds a border to a NamedRange control and sets the Color, LineStyle, and Weight properties for the new border.
Public method BorderAround2 Adds a border to a NamedRange control and sets the Color, LineStyle, and Weight properties for the new border.
Public method Calculate Calculates the values of cells in a NamedRange control.
Public method CalculateRowMajorOrder Calculates a specific range of cells.
Public method CheckSpelling Checks the spelling of text in the NamedRange control.
Public method Clear Clears the entire NamedRange control.
Public method ClearComments Clears all cell comments from the NamedRange control.
Public method ClearContents Clears the formulas from the NamedRange control.
Public method ClearFormats Clears the formatting of the NamedRange control.
Public method ClearHyperlinks Removes all hyperlinks from the specified range.
Public method ClearNotes Clears notes from all the cells in the NamedRange control.
Public method ClearOutline Clears the outline for the NamedRange control.
Public method ColumnDifferences Gets a Microsoft.Office.Interop.Excel.Range that represents all the cells whose contents are different from the comparison cell in each column.
Public method Consolidate Consolidates data from multiple ranges on multiple worksheets into the NamedRange control.
Public method Copy Copies the contents of the NamedRange control to the specified range or to the Clipboard.
Public method CopyFromRecordset Copies the contents of an ADO or DAO recordset into a worksheet, beginning at the upper-left corner of the NamedRange control.
Public method CopyPicture Copies the NamedRange control to the Clipboard as a picture.
Public method CreateNames Creates names in the NamedRange control, based on text labels in the sheet.
Public method CreatePublisher Infrastructure.
Public method Cut Cuts the contents of the NamedRange control to the Clipboard or pastes it into a specified destination.
Public method DataSeries Creates a data series in the NamedRange control.
Public method Delete Deletes a dynamically created NamedRange control and removes it from the ControlCollection.
Public method DialogBox Displays a dialog box defined by a dialog box definition table on a Microsoft Office Excel 4.0 macro sheet.
Public method Dirty Designates the NamedRange control to be recalculated when the next recalculation occurs.
Public method DiscardChanges Discards all changes in the edited cells of the range.
Public method Dispose Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.)
Public method EditionOptions Infrastructure.
Public method EndInit Signals the object that initialization is complete. (Inherited from ISupportInitialize.)
Public method ExportAsFixedFormat Exports to a file of the specified format.
Public method FillDown Fills down from the top cell or cells in the NamedRange control to the bottom of the NamedRange control.
Public method FillLeft Fills left from the rightmost cell or cells in the NamedRange control.
Public method FillRight Fills right from the leftmost cell or cells in the NamedRange control.
Public method FillUp Fills up from the bottom cell or cells in the NamedRange control to the top of the range.
Public method Find Finds specific information in the NamedRange control, and returns a Microsoft.Office.Interop.Excel.Range object that represents the first cell where that information is found.
Public method FindNext Continues a search that was begun with the Find method.
Public method FindPrevious Continues a search that was begun with the Find method.
Public method FunctionWizard Starts the Function Wizard for the upper-left cell of the NamedRange control.
Public method get_Address Infrastructure. Use the Address property instead of this method.
Public method get_AddressLocal Infrastructure. Use the AddressLocal property instead of this method.
Public method get_Characters Infrastructure. Use the Characters property instead of this method.
Public method get_End Infrastructure. Use the End property instead of this method.
Public method get_Item Infrastructure. Use the Item property instead of this method.
Public method get_Offset Infrastructure. Use the Offset property instead of this method.
Public method get_Range Infrastructure.
Public method get_Resize Infrastructure. Use the Resize property instead of this method.
Public method get_Value Gets the value of the NamedRange control.
Public method GetEnumerator Gets an IEnumerator that can be used to iterate over the cells in the NamedRange control.
Public method GoalSeek Calculates the values necessary to achieve a specific goal.
Public method Group When the NamedRange control represents a single cell in a PivotTable field’s data range, the Group method performs numeric or date-based grouping in that field.
Public method Insert Inserts a cell or a range of cells into the NamedRange control and shifts other cells away to make space.
Public method InsertIndent Adds an indent to the NamedRange control.
Public method Justify Rearranges the text in the NamedRange control so that it fills the range evenly.
Public method ListNames Pastes a list of all displayed names onto the worksheet, beginning with the first cell in the NamedRange control.
Public method Merge Creates a merged cell from the NamedRange control.
Public method NavigateArrow Navigates a tracer arrow for the NamedRange control to the precedent, dependent, or error-causing cell or cells.
Public method NoteText Gets or sets the cell note associated with the cell in the upper-left corner of the NamedRange control.
Public method Parse Parses a range of data and breaks it into multiple cells.
Public method PasteSpecial Pastes the contents of a Microsoft.Office.Interop.Excel.Range object from the Clipboard into the NamedRange control.
Public method PrintOut Prints the NamedRange control.
Public method PrintOutEx Prints the object.
Public method PrintPreview Shows a preview of the NamedRange control as it would look when printed.
Public method RemoveDuplicates Removes duplicate values from a range of values.
Public method RemoveSubtotal Removes subtotals from the NamedRange control.
Public method Replace Replaces the specified characters in the NamedRange control with a new string.
Public method RowDifferences Gets a Microsoft.Office.Interop.Excel.Range object that represents all the cells whose contents are different from those of the comparison cell in each row.
Public method Run Infrastructure.
Public method Select Selects the NamedRange control.
Public method set_Item Infrastructure. Use the Item property instead of this method.
Public method set_Value Sets the value of the NamedRange control.
Public method SetPhonetic Creates Phonetic objects for all the cells in the NamedRange control.
Public method Show Scrolls through the contents of the active window to move the NamedRange control into view.
Public method ShowDependents Draws tracer arrows to the direct dependents of the NamedRange control.
Public method ShowErrors Draws tracer arrows through the precedents tree to the cell that is the source of the error, and returns the Microsoft.Office.Interop.Excel.Range object that contains that cell.
Public method ShowPrecedents Draws tracer arrows to the direct precedents of the NamedRange control.
Public method Sort Sorts the data in a NamedRange control.
Public method SortSpecial Uses East Asian sorting methods to sort the NamedRange control. For example, Japanese sorts in the order of the Kana syllabary. For more information, see the parameters list.
Public method Speak Causes the cells of the NamedRange control to be spoken in row order or column order.
Public method SpecialCells Gets a Microsoft.Office.Interop.Excel.Range object that represents all the cells that match the specified type and value.
Public method SubscribeTo Infrastructure.
Public method Subtotal Creates subtotals for the NamedRange control.
Public method Table Creates a data table based on input values and formulas that you define in a worksheet.
Public method TextToColumns Parses a column of cells that contain text into several columns.
Public method Ungroup Promotes the NamedRange control in an outline (that is, decreases its outline level).
Public method UnMerge Separates a merged area into individual cells.
Top
Show:
© 2015 Microsoft