vba for excel worksheet 对象（VBA在Excel工作表对象）.docVIP

vba for excel worksheet 对象（VBA在Excel工作表对象） Worksheet object stands for a worksheet. Method Activatemakes the current worksheet an active worksheet. Calculatecalculates the cells in the specified worksheet or worksheet specified area in all open workbooks, workbooks, and tables as shown in the table below. ChartObjectsreturns an object that represents an embedded chart (ChartObject object) on a worksheet or a collection of all embedded diagrams (ChartObjects objects). Spelling of objects checked by CheckSpelling. CircleInvalidloops the invalid data items in the worksheet. ClearArrowsclears the trace arrows for the specified worksheet. Use the audit function to add tracking arrows. ClearCirclesclears the loop of the invalid data item of the specified worksheet. Copycopies the worksheet to another location of the workbook. Deletedelete object. Evaluateconverts a Microsoft Excel name to an object or a value. ExportAsFixedFormatexports files in specified format. Movemoves the worksheet to other locations in the workbook. OLEObjectsreturns an object that represents a single OLE object (OLEObject) on a graph or worksheet, or a collection of all OLE objects (OLEObjects set). Read-only. Pastepaste the clipboard content to the worksheet. PasteSpecialpaste the contents of the clipboard into the worksheet in a specified format. This method can be used to paste data from other applications or to paste data in a particular format. PivotTablesreturns an object that represents a single PivotTable (PivotTable object) on a worksheet or a collection of all PivotTable reports (PivotTables objects). Read-only. PivotTableWizardcreates a new pivottable. This method does not display the PivotTable wizard, and it does not apply to the OLE DB data source. Please use the Add method to add PivotTable cache, and then create PivotTable reports based on the cache. PrintOutprint object. PrintPreviewdisplays the object preview after the object is printed. Protectprotects the worksheet from being m