This topic has not yet been rated - Rate this topic

Worksheets Methods (Excel)

Office 2013

Published: July 16, 2012

This object has the following methods:

Name

Description

Add

Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet.

Add2

This method is only implemented for the Charts collection object and will produce a run time error if used on the Sheets and Worksheets objects.

Copy

Copies the sheet to another location in the workbook.

Delete

Deletes the object.

FillAcrossSheets

Copies a range to the same area on all other worksheets in a collection.

Move

Moves the sheet to another location in the workbook.

PrintOut

Prints the object.

PrintPreview

Shows a preview of the object as it would look when printed.

Select

Selects the object.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.