Developer Edition > Visual Basic for Applications (VBA) > Object Model Reference

Collection of pair objects.

Methods

Name	Description
AddMatched	Adds matched pairs using MatchType and MatchInclude properties.
AddPair	Adds a pair to the Pairs collection.
Clear	Clears the pairs collection.
Remove	Removes specified pair from the collection.

Properties

Name	Description
Count	Returns the number of members in the collection.
IsValid	Returns true if pairs exist and each pair is valid.
Item	Returns a single item (pair) from the collection.
MatchInclude	Returns or sets options specifying types of worksheets to include by AddMatched method.
MatchType	Returns or sets a constant specifying how worksheets will be matched by AddMatched method.
PasswordList	Returns or sets a semicolon delimited list of passwords needed to access protected sheets.

Events

Name	Description

none

Remarks

You can add pairs individually with the Add Method or use the AddMatched method to automatically add pairs for all worksheets that have matching names or indexes.

You can retrieve a specific pair with Pairs(Index) or Pairs.Item(Index).
You can remove a specific pair with Pairs.Remove(Index).
You can remove all pairs by using the Clear Method.

Pairs Object

Pairs Object

Methods

Properties

Events