Microsoft Office Tutorials and References
In Depth Information
Table 18-2. Members That Return Objects
Note that if neither Before nor After is specified, Excel will copy the worksheet to a
new workbook.
To illustrate, the following code copies the active worksheet and places the copy at the
end of the list of current worksheets:
ActiveSheet.Copy After:=Worksheets(Worksheets.Count)
Delete method
This method simply deletes the worksheet. The syntax is:
WorksheetObject .Delete
EnableCalculation property (R/W Boolean)
When this property is True , Excel automatically recalculates the worksheet when
necessary. Otherwise, the user must request a recalculation. Note that when this property
is first set to True , Excel will do a recalculation.
Evaluate method
The Evaluate method converts an Excel name to an object or a value. We discussed the
details of this method in Chapter 16 .
FilterMode property (Read-Only Boolean)
This property is True if the worksheet is in filter mode. Thus, for instance, if the
AutoFilter arrows are displayed but no filtering has taken place, then AutoFilterMode is
True whereas FilterMode is False . Once filtering is actually performed, then
FilterMode is True . Put another way, the FilterMode property indicates whether there are
hidden rows due to filtering.
Move method
The Move method moves the worksheet to another location in the workbook. The syntax
is:
WorksheetObject .Move( Before , After )
where the parameters have the same meaning as in the Copy method, discussed earlier in
this section.
Name property (R/W String)
This property returns or sets the name of the worksheet, as a string.
Names property
This property returns the Names collection representing all the worksheet-specific names.
For more on Name objects, see Chapter 16 .
PasteSpecial method
Search JabSto ::




Custom Search