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
To illustrate, the following code copies the active worksheet and places the copy at the
end of the list of current worksheets:
This method simply deletes the worksheet. The syntax is:
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.
The Evaluate method converts an Excel name to an object or a value. We discussed the
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.
The Move method moves the worksheet to another location in the workbook. The syntax
WorksheetObject .Move( Before , After )
where the parameters have the same meaning as in the Copy method, discussed earlier in
Name property (R/W String)
This property returns or sets the name of the worksheet, as a string.
This property returns the Names collection representing all the worksheet-specific names.