Worksheet methods

	Name	Description
	_CheckSpelling	Reserved for internal use. (Inherited from _Worksheet.)
	_Evaluate	Reserved for internal use. (Inherited from _Worksheet.)
	_PasteSpecial	Reserved for internal use. (Inherited from _Worksheet.)
	_PrintOut	Reserved for internal use. (Inherited from _Worksheet.)
	_Protect	Reserved for internal use. (Inherited from _Worksheet.)
	_SaveAs	Reserved for internal use. (Inherited from _Worksheet.)
	Activate	Makes the current sheet the active sheet. Equivalent to clicking the sheet's tab. (Inherited from _Worksheet.)
	Arcs	Reserved for internal use. (Inherited from _Worksheet.)
	Buttons	Reserved for internal use. (Inherited from _Worksheet.)
	Calculate	Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, as shown in the following table. (Inherited from _Worksheet.)
	ChartObjects	Returns an object that represents either a single embedded chart (a ChartObject object) or a collection of all the embedded charts (a ChartObjects object) on the sheet. (Inherited from _Worksheet.)
	CheckBoxes	Reserved for internal use. (Inherited from _Worksheet.)
	CheckSpelling	Checks the spelling of an object. This form has no return value; Microsoft Excel displays the Spelling dialog box. (Inherited from _Worksheet.)
	CircleInvalid	Circles invalid entries on the worksheet. (Inherited from _Worksheet.)
	ClearArrows	Clears the tracer arrows from the worksheet. Tracer arrows are added by using the auditing feature. (Inherited from _Worksheet.)
	ClearCircles	Clears circles from invalid entries on the worksheet. (Inherited from _Worksheet.)
	Copy	Copies the sheet to another location in the workbook. (Inherited from _Worksheet.)
	Delete	Deletes the object. (Inherited from _Worksheet.)
	DrawingObjects	Reserved for internal use. (Inherited from _Worksheet.)
	Drawings	Reserved for internal use. (Inherited from _Worksheet.)
	DropDowns	Reserved for internal use. (Inherited from _Worksheet.)
	Evaluate	Converts a Microsoft Excel name to an object or a value. (Inherited from _Worksheet.)
	ExportAsFixedFormat	Exports to a file of the specified format. (Inherited from _Worksheet.)
	GroupBoxes	Reserved for internal use. (Inherited from _Worksheet.)
	GroupObjects	Reserved for internal use. (Inherited from _Worksheet.)
	Labels	Reserved for internal use. (Inherited from _Worksheet.)
	Lines	Reserved for internal use. (Inherited from _Worksheet.)
	ListBoxes	Reserved for internal use. (Inherited from _Worksheet.)
	Move	Moves the sheet to another location in the workbook (Inherited from _Worksheet.)
	OLEObjects	Returns an object that represents either a single OLE object (an OLEObject) or a collection of all OLE objects (an OLEObjects collection) on the chart or sheet. Read-only. (Inherited from _Worksheet.)
	OptionButtons	Reserved for internal use. (Inherited from _Worksheet.)
	Ovals	Reserved for internal use. (Inherited from _Worksheet.)
	Paste	Pastes the contents of the Clipboard onto the sheet. (Inherited from _Worksheet.)
	PasteSpecial	Pastes the contents of the Clipboard onto the sheet using a specified format. Use this method to paste data from other applications or to paste data in a specific format. (Inherited from _Worksheet.)
	Pictures	Reserved for internal use. (Inherited from _Worksheet.)
	PivotTables	Returns an object that represents either a single PivotTable report (a PivotTable object) or a collection of all the PivotTable reports (a PivotTables object) on a worksheet. Read-only. (Inherited from _Worksheet.)
	PivotTableWizard	Creates a PivotTable object. This method doesn’t display the PivotTable Wizard. This method isn’t available for OLE DB data sources. Use the Add method to add a PivotTable cache, and then create a PivotTable report based on the cache. PivotTable object. (Inherited from _Worksheet.)
	PrintOut	Prints the object. (Inherited from _Worksheet.)
	PrintOutEx	Reserved for internal use. (Inherited from _Worksheet.)
	PrintPreview	Shows a preview of the object as it would look when printed. (Inherited from _Worksheet.)
	Protect	Protects a worksheet so that it cannot be modified. (Inherited from _Worksheet.)
	Rectangles	Reserved for internal use. (Inherited from _Worksheet.)
	ResetAllPageBreaks	Resets all page breaks on the specified worksheet. (Inherited from _Worksheet.)
	SaveAs	Saves changes to the chart or worksheet in a different file. (Inherited from _Worksheet.)
	Scenarios	Returns an object that represents either a single scenario (a Scenario object) or a collection of scenarios (a Scenarios object) on the worksheet. (Inherited from _Worksheet.)
	ScrollBars	Reserved for internal use. (Inherited from _Worksheet.)
	Select	Selects the object. (Inherited from _Worksheet.)
	SetBackgroundPicture	Sets the background graphic for a worksheet or chart. (Inherited from _Worksheet.)
	ShowAllData	Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All." (Inherited from _Worksheet.)
	ShowDataForm	Displays the data form associated with the worksheet. (Inherited from _Worksheet.)
	Spinners	Reserved for internal use. (Inherited from _Worksheet.)
	TextBoxes	Reserved for internal use. (Inherited from _Worksheet.)
	Unprotect	Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected. (Inherited from _Worksheet.)
	XmlDataQuery	Returns a Range object that represents the cells mapped to a particular XPath. Returns Nothing if the specified XPath has not been mapped to the worksheet or if the mapped range is empty. (Inherited from _Worksheet.)
	XmlMapQuery	Returns a Range object that represents the cells mapped to a particular XPath. Returns Nothing if the specified XPath has not been mapped to the worksheet. (Inherited from _Worksheet.)

Top

Reference