Returns or sets a variable specifying how worksheets will be matched by AddMatched method. MatchType constant.

Syntax

expression.MatchType

expression. A variable representing a Pairs object.

Example

This example adds all worksheets with equal names. 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

  .AddMatched

End With