ServerViewableItems.Add method (Excel)

Adds a reference to the ServerViewableItems collection.

Syntax

expression.Add (Obj)

expression A variable that represents a ServerViewableItems object.

Parameters

Name Required/Optional Data type Description
Obj Required Variant The reference to an object. The object can be a reference to sheets or named items (for example, named ranges, charts, tables, and PivotTables). You cannot have both sheets and named items in the same collection.

Return value

Object

Remarks

If you try to add a mix of both sheets and named items to the ServerViewableItems collection, an error is returned. The ServerViewableItems collection can contain references only to sheets, or references only to named items, but not to both in the same call.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.