<< Click to Display Table of Contents >> Pairs.MatchInclude Property |
Returns or sets options specifying types of worksheets to include by AddMatched method. MatchIncludeFlag constant.
expression.MatchInclude
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
.AddMatched
End With