Pairs.AddMatched Method

<< Click to Display Table of Contents >>

Navigation:  Developer Edition > Visual Basic for Applications (VBA) > Object Model Reference > Pairs Object > Methods >

Pairs.AddMatched Method

Previous pageReturn to chapter overviewNext page

Adds matched pairs using MatchType and MatchInclude properties.




expression. A variable representing a Pairs object.



This example adds all worksheets with the same name. Protected and hidden sheets are included.


With .Pairs

  'include protected and hidden sheets

  .MatchInclude = MatchIncludeFlag_ProtectedSheets + MatchIncludeFlag_HiddenSheets

  'match all sheets with same name

  .MatchType = MatchType_AllByName

  'add sheets


End With