VBA for Excel Worksheet 对象(国外英语资料).doc

VBA for Excel Worksheet 对象(国外英语资料) The Worksheet object represents a Worksheet. methods Activate makes the current worksheet the active worksheet. Calculate calculates all the open worksheets, a specific worksheet in the workbook, or the cell in the work table, as shown in the table below. ChartObjects returns an object that represents a collection of embedded diagrams (ChartObject objects) on the worksheet or all the sets of embedded diagrams (ChartObjects objects). CheckSpelling check the spelling of the object. CircleInvalid circles the invalid data item in the worksheet. ClearArrows clears the trace arrows for the worksheet. Use the auditing feature to add tracing arrows. ClearCircles clears the ring of invalid data items for the specified worksheet. Copy the worksheet to another location in the workbook. Delete Delete the object. Evaluate converts a Microsoft Excel name to an object or a value. The ExportAsFixedFormat is exported as a file in the specified format. Move moves the worksheet to other locations in the workbook. OLEObjects returns an object that represents a collection of single OLE objects (OLEObjects) or all OLE objects on a chart or worksheet. Read-only. Paste Paste the contents of the clipboard onto the worksheet. Pastspecial al pasted the contents of the clipboard to the worksheet in a specified format. You can use this method to paste data from other applications, or paste data in a specific format. The PivotTables returns an object that represents a single data perspective table (PivotTable object) on the worksheet or a collection of all pivot tables (PivotTables). Read-only. The PivotTableWizard creates a new data perspective table. This method does not display the pivot table wizard, which does not apply to the OLE DB data source. Add the data perspective table cache using the Add method and create a data perspective table based on that cache. PrintOut print object. PrintPreview prints a preview of the object after the object is printed.