Combine Multiple (50 or More) Workbooks with VBA

I

innoin

New Member
Joined
May 4, 2017
Messages
33
Hello everyone! I've been scouring the internet for the last hour trying to find some kind of code that would help me combine multiple spreadsheets into one "master" spreadsheet. I've found quite a few that seem like they work, but even with my tweaks I can't seem to make them work (I'm not too knowledgeable of Excel so I'm sure it's my ineptitude and not the code). It may be because column A and row 1 are empty on the spreadsheets I'm trying to combine and maybe the code is stopping immediately? I tested that theory on a couple of the ones I've found, but it didn't seem to help. I just want to copy everything from the first workbook, paste in the master, then copy the next file, and paste all that data in the next open row. I don't see a spot to upload a sample of the look of the file, but I can copy and paste if needed. So, that's the first thing I need help with.

The second thing is a bit more complicated. I am going to use this to search certain areas of the document for the greatest values. I will basically use this to search G16 through G23, enter the greatest value found into H1, then search G27 through G34 and enter that greatest value in I1...and so on (continuing on to J, K L), then start again with the next workbooks data and enter it's first greatest value in H2, then I2 and so on. Maybe someone could help with that and incorporate it into the code as well? I'm bad, but not terrible at editing VBA so I could probably stumble through editing if given something with the gist of it. I can assign the actual areas it needs to search and copy and paste if needed. Thanks for any help!
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Sort by date Sort by votes
Hello again! SO! I found something that works, but it combines all the excel files into different sheets (the one I just ran created nearly 150 sheets). I will have to do this to thousands more is why I'm a bit panicked about this! I want to be able to combine hundreds or even a few thousand if possible. If it's not possible, 150 would work.

Would it be difficult to create a macro that searches across all sheets for the values below, then puts the greatest (or min/max in certain cases) values on a new sheet? I would be eternally in your debt if you can figure this out!

H16 through H23 (Search all sheets and takes only the largest number out of all of them in these cells and puts it in cell A2 on a new sheet)
H27 through H34 (Same as above into cell B2)
L75 through L80 (Same as above, but also grabs the minimum - i.e. places the largest value in cell C2 and the smallest negative value in cell D2 right next to it on the new sheet)
L87 through L91 (Same as above with min/max in cells E2 and F2)
H95 (only the largest across all sheets into cell G2)
H99 (only the largest across all sheets into cell H2)

It would be great if the new sheet would have the titles in this order and then the data appears in the cell right below in the order of listing above:
A1 (DIM 1 DIA) B1 (DIM 1 POS) C1 (DIM 5 MIN) D1 (DIM 5 MAX) E1 (DIM 6 MIN) F1 (DIM 6 MAX) G1 (DIM 8 DIA) H1 (DIM 8 POS)

I have no idea how massive of a project this is…but even a bit of help would go a long way (maybe…I’m quite bad with Excel and coding in general…but I might be able to figure it out if I can just see what you do for the first couple searches).
 
Upvote 0
innoin said:
Hello again! SO! I found something that works, but it combines all the excel files into different sheets (the one I just ran created nearly 150 sheets). I will have to do this to thousands more is why I'm a bit panicked about this! I want to be able to combine hundreds or even a few thousand if possible. If it's not possible, 150 would work.
Would it be difficult to create a macro that searches across all sheets for the values below, then puts the greatest (or min/max in certain cases) values on a new sheet?
Click to expand...

Try this:
In the combined workbook (with ~150 sheets), create a new sheet, name it "TEMP", then run the code.


Code: 
[FONT=lucida console][color=Royalblue]Sub[/color] a1092546a()
[i][color=seagreen]'https://www.mrexcel.com/forum/excel-questions/1092546-combine-multiple-50-more-workbooks-vba.html[/color][/i]

[color=Royalblue]Dim[/color] ws [color=Royalblue]As[/color] Worksheet, t
[color=Royalblue]Dim[/color] z1 [color=Royalblue]As[/color] [color=Royalblue]Double[/color], x1 [color=Royalblue]As[/color] [color=Royalblue]Double[/color]
[color=Royalblue]Dim[/color] z2 [color=Royalblue]As[/color] [color=Royalblue]Double[/color], x2 [color=Royalblue]As[/color] [color=Royalblue]Double[/color]
[color=Royalblue]Dim[/color] z3 [color=Royalblue]As[/color] [color=Royalblue]Double[/color], x3 [color=Royalblue]As[/color] [color=Royalblue]Double[/color]
[color=Royalblue]Dim[/color] z4 [color=Royalblue]As[/color] [color=Royalblue]Double[/color], x4 [color=Royalblue]As[/color] [color=Royalblue]Double[/color]
[color=Royalblue]Dim[/color] z5 [color=Royalblue]As[/color] [color=Royalblue]Double[/color], x5 [color=Royalblue]As[/color] [color=Royalblue]Double[/color]
[color=Royalblue]Dim[/color] z6 [color=Royalblue]As[/color] [color=Royalblue]Double[/color], x6 [color=Royalblue]As[/color] [color=Royalblue]Double[/color]
[color=Royalblue]Dim[/color] z7 [color=Royalblue]As[/color] [color=Royalblue]Double[/color], x7 [color=Royalblue]As[/color] [color=Royalblue]Double[/color]
[color=Royalblue]Dim[/color] z8 [color=Royalblue]As[/color] [color=Royalblue]Double[/color], x8 [color=Royalblue]As[/color] [color=Royalblue]Double[/color]

t = Timer
[color=Royalblue]For[/color] [color=Royalblue]Each[/color] ws [color=Royalblue]In[/color] Worksheets
    [color=Royalblue]If[/color] UCase(ws.Name) <> UCase([color=brown]"TEMP"[/color]) [color=Royalblue]Then[/color]
        [color=Royalblue]With[/color] ws
                   
            [color=Royalblue]If[/color] Len(z1) = [color=crimson]0[/color] [color=Royalblue]Then[/color] z1 = WorksheetFunction.Max(.Range([color=brown]"H16:H23"[/color]))
            [color=Royalblue]If[/color] Len(z2) = [color=crimson]0[/color] [color=Royalblue]Then[/color] z2 = WorksheetFunction.Max(.Range([color=brown]"H27:H34"[/color]))
            [color=Royalblue]If[/color] Len(z3) = [color=crimson]0[/color] [color=Royalblue]Then[/color] z3 = WorksheetFunction.Max(.Range([color=brown]"L75:L80"[/color]))
            [color=Royalblue]If[/color] Len(z4) = [color=crimson]0[/color] [color=Royalblue]Then[/color] z4 = WorksheetFunction.Min(.Range([color=brown]"L75:L80"[/color]))
            [color=Royalblue]If[/color] Len(z5) = [color=crimson]0[/color] [color=Royalblue]Then[/color] z5 = WorksheetFunction.Max(.Range([color=brown]"L87:L91"[/color]))
            [color=Royalblue]If[/color] Len(z6) = [color=crimson]0[/color] [color=Royalblue]Then[/color] z6 = WorksheetFunction.Min(.Range([color=brown]"L87:L91"[/color]))
            [color=Royalblue]If[/color] Len(z7) = [color=crimson]0[/color] [color=Royalblue]Then[/color] z7 = .Range([color=brown]"H95"[/color])
            [color=Royalblue]If[/color] Len(z8) = [color=crimson]0[/color] [color=Royalblue]Then[/color] z8 = .Range([color=brown]"H99"[/color])
            
            x1 = WorksheetFunction.Max(.Range([color=brown]"H16:H23"[/color])): [color=Royalblue]If[/color] x1 > z1 [color=Royalblue]Then[/color] z1 = x1
            x2 = WorksheetFunction.Max(.Range([color=brown]"H27:H34"[/color])): [color=Royalblue]If[/color] x2 > z2 [color=Royalblue]Then[/color] z2 = x2
            x3 = WorksheetFunction.Max(.Range([color=brown]"L75:L80"[/color])): [color=Royalblue]If[/color] x3 > z3 [color=Royalblue]Then[/color] z3 = x3
            x4 = WorksheetFunction.Min(.Range([color=brown]"L75:L80"[/color])): [color=Royalblue]If[/color] x4 < z4 [color=Royalblue]Then[/color] z4 = x4 [i][color=seagreen]'Min[/color][/i]
            x5 = WorksheetFunction.Max(.Range([color=brown]"L87:L91"[/color])): [color=Royalblue]If[/color] x5 > z5 [color=Royalblue]Then[/color] z5 = x5
            x6 = WorksheetFunction.Min(.Range([color=brown]"L87:L91"[/color])): [color=Royalblue]If[/color] x6 < z6 [color=Royalblue]Then[/color] z6 = x6 [i][color=seagreen]'Min[/color][/i]
            x7 = .Range([color=brown]"H95"[/color]):     [color=Royalblue]If[/color] x7 > z7 [color=Royalblue]Then[/color] z7 = x7
            x8 = .Range([color=brown]"H99"[/color]):     [color=Royalblue]If[/color] x8 > z8 [color=Royalblue]Then[/color] z8 = x8
            
        [color=Royalblue]End[/color] [color=Royalblue]With[/color]
    [color=Royalblue]End[/color] [color=Royalblue]If[/color]
[color=Royalblue]Next[/color]

[color=Royalblue]With[/color] Sheets([color=brown]"TEMP"[/color])

.Range([color=brown]"A1"[/color]) = [color=brown]"(DIM 1 DIA)"[/color]
.Range([color=brown]"B1"[/color]) = [color=brown]"(DIM 1 POS)"[/color]
.Range([color=brown]"C1"[/color]) = [color=brown]"(DIM 5 MIN)"[/color]
.Range([color=brown]"D1"[/color]) = [color=brown]"(DIM 5 MAX)"[/color]
.Range([color=brown]"E1"[/color]) = [color=brown]"(DIM 6 MIN)"[/color]
.Range([color=brown]"F1"[/color]) = [color=brown]"(DIM 6 MAX)"[/color]
.Range([color=brown]"G1"[/color]) = [color=brown]"(DIM 8 DIA)"[/color]
.Range([color=brown]"H1"[/color]) = [color=brown]"(DIM 8 POS)"[/color]

.Range([color=brown]"A2"[/color]) = z1
.Range([color=brown]"B2"[/color]) = z2
.Range([color=brown]"C2"[/color]) = z3
.Range([color=brown]"D2"[/color]) = z4
.Range([color=brown]"E2"[/color]) = z5
.Range([color=brown]"F2"[/color]) = z6
.Range([color=brown]"G2"[/color]) = z7
.Range([color=brown]"H2"[/color]) = z8

[color=Royalblue]End[/color] [color=Royalblue]With[/color]

    MsgBox [color=brown]"It's done in "[/color] & Timer - t & [color=brown]" seconds"[/color]


[color=Royalblue]End[/color] [color=Royalblue]Sub[/color][/FONT]
 
Last edited:
Upvote 0
Akuini said:
Try this:
In the combined workbook (with ~150 sheets), create a new sheet, name it "TEMP", then run the code.


Code: 
[FONT=lucida console][COLOR=Royalblue]Sub[/COLOR] a1092546a()
[I][COLOR=seagreen]'https://www.mrexcel.com/forum/excel-questions/1092546-combine-multiple-50-more-workbooks-vba.html[/COLOR][/I]

[COLOR=Royalblue]Dim[/COLOR] ws [COLOR=Royalblue]As[/COLOR] Worksheet, t
[COLOR=Royalblue]Dim[/COLOR] z1 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x1 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z2 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x2 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z3 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x3 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z4 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x4 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z5 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x5 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z6 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x6 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z7 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x7 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z8 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x8 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]

t = Timer
[COLOR=Royalblue]For[/COLOR] [COLOR=Royalblue]Each[/COLOR] ws [COLOR=Royalblue]In[/COLOR] Worksheets
    [COLOR=Royalblue]If[/COLOR] UCase(ws.Name) <> UCase([COLOR=brown]"TEMP"[/COLOR]) [COLOR=Royalblue]Then[/COLOR]
        [COLOR=Royalblue]With[/COLOR] ws
                   
            [COLOR=Royalblue]If[/COLOR] Len(z1) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z1 = WorksheetFunction.Max(.Range([COLOR=brown]"H16:H23"[/COLOR]))
            [COLOR=Royalblue]If[/COLOR] Len(z2) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z2 = WorksheetFunction.Max(.Range([COLOR=brown]"H27:H34"[/COLOR]))
            [COLOR=Royalblue]If[/COLOR] Len(z3) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z3 = WorksheetFunction.Max(.Range([COLOR=brown]"L75:L80"[/COLOR]))
            [COLOR=Royalblue]If[/COLOR] Len(z4) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z4 = WorksheetFunction.Min(.Range([COLOR=brown]"L75:L80"[/COLOR]))
            [COLOR=Royalblue]If[/COLOR] Len(z5) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z5 = WorksheetFunction.Max(.Range([COLOR=brown]"L87:L91"[/COLOR]))
            [COLOR=Royalblue]If[/COLOR] Len(z6) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z6 = WorksheetFunction.Min(.Range([COLOR=brown]"L87:L91"[/COLOR]))
            [COLOR=Royalblue]If[/COLOR] Len(z7) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z7 = .Range([COLOR=brown]"H95"[/COLOR])
            [COLOR=Royalblue]If[/COLOR] Len(z8) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z8 = .Range([COLOR=brown]"H99"[/COLOR])
            
            x1 = WorksheetFunction.Max(.Range([COLOR=brown]"H16:H23"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x1 > z1 [COLOR=Royalblue]Then[/COLOR] z1 = x1
            x2 = WorksheetFunction.Max(.Range([COLOR=brown]"H27:H34"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x2 > z2 [COLOR=Royalblue]Then[/COLOR] z2 = x2
            x3 = WorksheetFunction.Max(.Range([COLOR=brown]"L75:L80"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x3 > z3 [COLOR=Royalblue]Then[/COLOR] z3 = x3
            x4 = WorksheetFunction.Min(.Range([COLOR=brown]"L75:L80"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x4 < z4 [COLOR=Royalblue]Then[/COLOR] z4 = x4 [I][COLOR=seagreen]'Min[/COLOR][/I]
            x5 = WorksheetFunction.Max(.Range([COLOR=brown]"L87:L91"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x5 > z5 [COLOR=Royalblue]Then[/COLOR] z5 = x5
            x6 = WorksheetFunction.Min(.Range([COLOR=brown]"L87:L91"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x6 < z6 [COLOR=Royalblue]Then[/COLOR] z6 = x6 [I][COLOR=seagreen]'Min[/COLOR][/I]
            x7 = .Range([COLOR=brown]"H95"[/COLOR]):     [COLOR=Royalblue]If[/COLOR] x7 > z7 [COLOR=Royalblue]Then[/COLOR] z7 = x7
            x8 = .Range([COLOR=brown]"H99"[/COLOR]):     [COLOR=Royalblue]If[/COLOR] x8 > z8 [COLOR=Royalblue]Then[/COLOR] z8 = x8
            
        [COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]With[/COLOR]
    [COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]If[/COLOR]
[COLOR=Royalblue]Next[/COLOR]

[COLOR=Royalblue]With[/COLOR] Sheets([COLOR=brown]"TEMP"[/COLOR])

.Range([COLOR=brown]"A1"[/COLOR]) = [COLOR=brown]"(DIM 1 DIA)"[/COLOR]
.Range([COLOR=brown]"B1"[/COLOR]) = [COLOR=brown]"(DIM 1 POS)"[/COLOR]
.Range([COLOR=brown]"C1"[/COLOR]) = [COLOR=brown]"(DIM 5 MIN)"[/COLOR]
.Range([COLOR=brown]"D1"[/COLOR]) = [COLOR=brown]"(DIM 5 MAX)"[/COLOR]
.Range([COLOR=brown]"E1"[/COLOR]) = [COLOR=brown]"(DIM 6 MIN)"[/COLOR]
.Range([COLOR=brown]"F1"[/COLOR]) = [COLOR=brown]"(DIM 6 MAX)"[/COLOR]
.Range([COLOR=brown]"G1"[/COLOR]) = [COLOR=brown]"(DIM 8 DIA)"[/COLOR]
.Range([COLOR=brown]"H1"[/COLOR]) = [COLOR=brown]"(DIM 8 POS)"[/COLOR]

.Range([COLOR=brown]"A2"[/COLOR]) = z1
.Range([COLOR=brown]"B2"[/COLOR]) = z2
.Range([COLOR=brown]"C2"[/COLOR]) = z3
.Range([COLOR=brown]"D2"[/COLOR]) = z4
.Range([COLOR=brown]"E2"[/COLOR]) = z5
.Range([COLOR=brown]"F2"[/COLOR]) = z6
.Range([COLOR=brown]"G2"[/COLOR]) = z7
.Range([COLOR=brown]"H2"[/COLOR]) = z8

[COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]With[/COLOR]

    MsgBox [COLOR=brown]"It's done in "[/COLOR] & Timer - t & [COLOR=brown]" seconds"[/COLOR]


[COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]Sub[/COLOR][/FONT]
Click to expand...

Thank you! This is amazing!!! This will be a massive help. One problem though...Cell E2 (the DIM 6 MIN) value is always 0. I'm not sure why this is happening because none of the values are 0. All the numbers in this field are negative numbers so that might be causing the problem? Or something else entirely? Any recommendations? Either way, thank you again!
 
Upvote 0
innoin said:
Thank you! This is amazing!!! This will be a massive help. One problem though...Cell E2 (the DIM 6 MIN) value is always 0. I'm not sure why this is happening because none of the values are 0. All the numbers in this field are negative numbers so that might be causing the problem? Or something else entirely? Any recommendations? Either way, thank you again!
Click to expand...


Is it possible that any sheet has all blank in Range("L87:L91")? I mean all cells in that range are blank, because if it is then the “WorksheetFunction.Max” will return 0, so 0 will be the maximum value (since values in other sheets are negative).

If that is the case then we need to revise the code.
Any other field has only negative number?

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false" DefSemiHidden="false" DefQFormat="false" DefPriority="99" LatentStyleCount="371"> <w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 9"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="header"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footer"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index heading"/> <w:LsdException Locked="false" Priority="35" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="caption"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of figures"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope return"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="line number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="page number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of authorities"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="macro"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="toa heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 5"/> <w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Closing"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Signature"/> <w:LsdException Locked="false" Priority="1" SemiHidden="true" UnhideWhenUsed="true" Name="Default Paragraph Font"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Message Header"/> <w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Salutation"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Date"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Note Heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Block Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Hyperlink"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="FollowedHyperlink"/> <w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Document Map"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Plain Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="E-mail Signature"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Top of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Bottom of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal (Web)"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Acronym"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Cite"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Code"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Definition"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Keyboard"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Preformatted"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Sample"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Typewriter"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Variable"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Table"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation subject"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="No List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Contemporary"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Elegant"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Professional"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Balloon Text"/> <w:LsdException Locked="false" Priority="39" Name="Table Grid"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Theme"/> <w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" Name="Light List"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" SemiHidden="true" Name="Revision"/> <w:LsdException Locked="false" Priority="34" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" SemiHidden="true" UnhideWhenUsed="true" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/> <w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/> <w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/> <w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/> <w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/> <w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/> <w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 6"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0cm; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} </style> <![endif]-->
 
Last edited:
Upvote 0
Akuini said:
Is it possible that any sheet has all blank in Range("L87:L91")? I mean all cells in that range are blank, because if it is then the “WorksheetFunction.Max” will return 0, so 0 will be the maximum value (since values in other sheets are negative).

If that is the case then we need to revise the code.
Any other field has only negative number?

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false" DefSemiHidden="false" DefQFormat="false" DefPriority="99" LatentStyleCount="371"> <w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 9"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="header"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footer"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index heading"/> <w:LsdException Locked="false" Priority="35" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="caption"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of figures"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope return"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="line number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="page number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of authorities"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="macro"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="toa heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 5"/> <w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Closing"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Signature"/> <w:LsdException Locked="false" Priority="1" SemiHidden="true" UnhideWhenUsed="true" Name="Default Paragraph Font"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Message Header"/> <w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Salutation"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Date"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Note Heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Block Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Hyperlink"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="FollowedHyperlink"/> <w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Document Map"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Plain Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="E-mail Signature"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Top of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Bottom of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal (Web)"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Acronym"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Cite"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Code"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Definition"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Keyboard"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Preformatted"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Sample"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Typewriter"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Variable"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Table"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation subject"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="No List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Contemporary"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Elegant"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Professional"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Balloon Text"/> <w:LsdException Locked="false" Priority="39" Name="Table Grid"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Theme"/> <w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" Name="Light List"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" SemiHidden="true" Name="Revision"/> <w:LsdException Locked="false" Priority="34" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" SemiHidden="true" UnhideWhenUsed="true" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/> <w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/> <w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/> <w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/> <w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/> <w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/> <w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 6"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0cm; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} </style> <![endif]-->
Click to expand...

Nope, none of the cells are blank. The largest largest deviation is -0.0159 and the smallest is -0.0098. There aren't any blank cells between L87 and L91 on any sheet. I also tested it by only checking three sheets and it did the same thing. Typically these are the only cells that will have all negative numbers, but occasionally DIM 5 will as well. I also just tested to see if it would do the same thing for DIM 5 by changing all the numbers to negative and it still found the min/max deviations. Strange since I don't see anything different in your code...
 
Upvote 0
I also just tested to see if it would do the same thing for DIM 5 by changing all the numbers to negative and it still found the min/max deviations. Strange since I don't see anything different in your code
Click to expand...
Hm, that’s strange. Can you try changing one cell in Range("L87:L91") to positive number?
Then tell me what happen.
 
Last edited:
Upvote 0
Akuini said:
Hm, that’s strange. Can you try changing one cell in Range("L87:L91") to positive number?
Then tell me what happen.
Click to expand...

It works when I change the number to a positive...and I just rechecked if it worked on DIM 5 and it doesn't. I must have missed one of the numbers when I tested it before. Sorry about that. So it definitely is the negative numbers tripping it up.
 
Upvote 0
innoin said:
It works when I change the number to a positive...and I just rechecked if it worked on DIM 5 and it doesn't. I must have missed one of the numbers when I tested it before. Sorry about that. So it definitely is the negative numbers tripping it up.
Click to expand...


Ok, try this:
I assigned -1000000 to z3 & z5 before the code finding the max value. Basically I just need a number that won’t be higher than any data in DIM 5 & DIM 6, actually -10 maybe is fine too.

Code: 
[FONT=lucida console][COLOR=Royalblue]Sub[/COLOR] a1092546c()
[I][COLOR=seagreen]'https://www.mrexcel.com/forum/excel-questions/1092546-combine-multiple-50-more-workbooks-vba.html[/COLOR][/I]

[COLOR=Royalblue]Dim[/COLOR] ws [COLOR=Royalblue]As[/COLOR] Worksheet, t
[COLOR=Royalblue]Dim[/COLOR] z1 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x1 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z2 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x2 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z3 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x3 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z4 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x4 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z5 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x5 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z6 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x6 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z7 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x7 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z8 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x8 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]

t = Timer

z3 = -[COLOR=crimson]1000000[/COLOR]
z5 = -[COLOR=crimson]1000000[/COLOR]

[COLOR=Royalblue]For[/COLOR] [COLOR=Royalblue]Each[/COLOR] ws [COLOR=Royalblue]In[/COLOR] Worksheets
    [COLOR=Royalblue]If[/COLOR] UCase(ws.Name) <> UCase([COLOR=brown]"TEMP"[/COLOR]) [COLOR=Royalblue]Then[/COLOR]
        [COLOR=Royalblue]With[/COLOR] ws
                   
            [COLOR=Royalblue]If[/COLOR] Len(z1) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z1 = WorksheetFunction.Max(.Range([COLOR=brown]"H16:H23"[/COLOR]))
            [COLOR=Royalblue]If[/COLOR] Len(z2) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z2 = WorksheetFunction.Max(.Range([COLOR=brown]"H27:H34"[/COLOR]))
[I][COLOR=seagreen]'            If Len(z3) = 0 Then z3 = WorksheetFunction.Max(.Range("L75:L80"))[/COLOR][/I]
            [COLOR=Royalblue]If[/COLOR] Len(z4) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z4 = WorksheetFunction.Min(.Range([COLOR=brown]"L75:L80"[/COLOR]))
[I][COLOR=seagreen]'            If Len(z5) = 0 Then z5 = WorksheetFunction.Max(.Range("L87:L91"))[/COLOR][/I]
            [COLOR=Royalblue]If[/COLOR] Len(z6) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z6 = WorksheetFunction.Min(.Range([COLOR=brown]"L87:L91"[/COLOR]))
            [COLOR=Royalblue]If[/COLOR] Len(z7) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z7 = .Range([COLOR=brown]"H95"[/COLOR])
            [COLOR=Royalblue]If[/COLOR] Len(z8) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z8 = .Range([COLOR=brown]"H99"[/COLOR])
            
            x1 = WorksheetFunction.Max(.Range([COLOR=brown]"H16:H23"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x1 > z1 [COLOR=Royalblue]Then[/COLOR] z1 = x1
            x2 = WorksheetFunction.Max(.Range([COLOR=brown]"H27:H34"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x2 > z2 [COLOR=Royalblue]Then[/COLOR] z2 = x2
            x3 = WorksheetFunction.Max(.Range([COLOR=brown]"L75:L80"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x3 > z3 [COLOR=Royalblue]Then[/COLOR] z3 = x3
            x4 = WorksheetFunction.Min(.Range([COLOR=brown]"L75:L80"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x4 < z4 [COLOR=Royalblue]Then[/COLOR] z4 = x4 [I][COLOR=seagreen]'Min[/COLOR][/I]
            x5 = WorksheetFunction.Max(.Range([COLOR=brown]"L87:L91"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x5 > z5 [COLOR=Royalblue]Then[/COLOR] z5 = x5
            x6 = WorksheetFunction.Min(.Range([COLOR=brown]"L87:L91"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x6 < z6 [COLOR=Royalblue]Then[/COLOR] z6 = x6 [I][COLOR=seagreen]'Min[/COLOR][/I]
            x7 = .Range([COLOR=brown]"H95"[/COLOR]):     [COLOR=Royalblue]If[/COLOR] x7 > z7 [COLOR=Royalblue]Then[/COLOR] z7 = x7
            x8 = .Range([COLOR=brown]"H99"[/COLOR]):     [COLOR=Royalblue]If[/COLOR] x8 > z8 [COLOR=Royalblue]Then[/COLOR] z8 = x8
            
        [COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]With[/COLOR]
    [COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]If[/COLOR]
[COLOR=Royalblue]Next[/COLOR]

[COLOR=Royalblue]With[/COLOR] Sheets([COLOR=brown]"TEMP"[/COLOR])

.Range([COLOR=brown]"A1"[/COLOR]) = [COLOR=brown]"(DIM 1 DIA)"[/COLOR]
.Range([COLOR=brown]"B1"[/COLOR]) = [COLOR=brown]"(DIM 1 POS)"[/COLOR]
.Range([COLOR=brown]"C1"[/COLOR]) = [COLOR=brown]"(DIM 5 MIN)"[/COLOR]
.Range([COLOR=brown]"D1"[/COLOR]) = [COLOR=brown]"(DIM 5 MAX)"[/COLOR]
.Range([COLOR=brown]"E1"[/COLOR]) = [COLOR=brown]"(DIM 6 MIN)"[/COLOR]
.Range([COLOR=brown]"F1"[/COLOR]) = [COLOR=brown]"(DIM 6 MAX)"[/COLOR]
.Range([COLOR=brown]"G1"[/COLOR]) = [COLOR=brown]"(DIM 8 DIA)"[/COLOR]
.Range([COLOR=brown]"H1"[/COLOR]) = [COLOR=brown]"(DIM 8 POS)"[/COLOR]

.Range([COLOR=brown]"A2"[/COLOR]) = z1
.Range([COLOR=brown]"B2"[/COLOR]) = z2
.Range([COLOR=brown]"C2"[/COLOR]) = z3
.Range([COLOR=brown]"D2"[/COLOR]) = z4
.Range([COLOR=brown]"E2"[/COLOR]) = z5
.Range([COLOR=brown]"F2"[/COLOR]) = z6
.Range([COLOR=brown]"G2"[/COLOR]) = z7
.Range([COLOR=brown]"H2"[/COLOR]) = z8

[COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]With[/COLOR]

    MsgBox [COLOR=brown]"It's done in "[/COLOR] & Timer - t & [COLOR=brown]" seconds"[/COLOR]


[COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]Sub[/COLOR][/FONT]
 
Upvote 0
Akuini said:
Ok, try this:
I assigned -1000000 to z3 & z5 before the code finding the max value. Basically I just need a number that won’t be higher than any data in DIM 5 & DIM 6, actually -10 maybe is fine too.

Code: 
[FONT=lucida console][COLOR=Royalblue]Sub[/COLOR] a1092546c()
[I][COLOR=seagreen]'https://www.mrexcel.com/forum/excel-questions/1092546-combine-multiple-50-more-workbooks-vba.html[/COLOR][/I]

[COLOR=Royalblue]Dim[/COLOR] ws [COLOR=Royalblue]As[/COLOR] Worksheet, t
[COLOR=Royalblue]Dim[/COLOR] z1 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x1 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z2 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x2 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z3 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x3 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z4 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x4 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z5 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x5 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z6 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x6 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z7 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x7 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]
[COLOR=Royalblue]Dim[/COLOR] z8 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR], x8 [COLOR=Royalblue]As[/COLOR] [COLOR=Royalblue]Double[/COLOR]

t = Timer

z3 = -[COLOR=crimson]1000000[/COLOR]
z5 = -[COLOR=crimson]1000000[/COLOR]

[COLOR=Royalblue]For[/COLOR] [COLOR=Royalblue]Each[/COLOR] ws [COLOR=Royalblue]In[/COLOR] Worksheets
    [COLOR=Royalblue]If[/COLOR] UCase(ws.Name) <> UCase([COLOR=brown]"TEMP"[/COLOR]) [COLOR=Royalblue]Then[/COLOR]
        [COLOR=Royalblue]With[/COLOR] ws
                   
            [COLOR=Royalblue]If[/COLOR] Len(z1) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z1 = WorksheetFunction.Max(.Range([COLOR=brown]"H16:H23"[/COLOR]))
            [COLOR=Royalblue]If[/COLOR] Len(z2) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z2 = WorksheetFunction.Max(.Range([COLOR=brown]"H27:H34"[/COLOR]))
[I][COLOR=seagreen]'            If Len(z3) = 0 Then z3 = WorksheetFunction.Max(.Range("L75:L80"))[/COLOR][/I]
            [COLOR=Royalblue]If[/COLOR] Len(z4) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z4 = WorksheetFunction.Min(.Range([COLOR=brown]"L75:L80"[/COLOR]))
[I][COLOR=seagreen]'            If Len(z5) = 0 Then z5 = WorksheetFunction.Max(.Range("L87:L91"))[/COLOR][/I]
            [COLOR=Royalblue]If[/COLOR] Len(z6) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z6 = WorksheetFunction.Min(.Range([COLOR=brown]"L87:L91"[/COLOR]))
            [COLOR=Royalblue]If[/COLOR] Len(z7) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z7 = .Range([COLOR=brown]"H95"[/COLOR])
            [COLOR=Royalblue]If[/COLOR] Len(z8) = [COLOR=crimson]0[/COLOR] [COLOR=Royalblue]Then[/COLOR] z8 = .Range([COLOR=brown]"H99"[/COLOR])
            
            x1 = WorksheetFunction.Max(.Range([COLOR=brown]"H16:H23"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x1 > z1 [COLOR=Royalblue]Then[/COLOR] z1 = x1
            x2 = WorksheetFunction.Max(.Range([COLOR=brown]"H27:H34"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x2 > z2 [COLOR=Royalblue]Then[/COLOR] z2 = x2
            x3 = WorksheetFunction.Max(.Range([COLOR=brown]"L75:L80"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x3 > z3 [COLOR=Royalblue]Then[/COLOR] z3 = x3
            x4 = WorksheetFunction.Min(.Range([COLOR=brown]"L75:L80"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x4 < z4 [COLOR=Royalblue]Then[/COLOR] z4 = x4 [I][COLOR=seagreen]'Min[/COLOR][/I]
            x5 = WorksheetFunction.Max(.Range([COLOR=brown]"L87:L91"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x5 > z5 [COLOR=Royalblue]Then[/COLOR] z5 = x5
            x6 = WorksheetFunction.Min(.Range([COLOR=brown]"L87:L91"[/COLOR])): [COLOR=Royalblue]If[/COLOR] x6 < z6 [COLOR=Royalblue]Then[/COLOR] z6 = x6 [I][COLOR=seagreen]'Min[/COLOR][/I]
            x7 = .Range([COLOR=brown]"H95"[/COLOR]):     [COLOR=Royalblue]If[/COLOR] x7 > z7 [COLOR=Royalblue]Then[/COLOR] z7 = x7
            x8 = .Range([COLOR=brown]"H99"[/COLOR]):     [COLOR=Royalblue]If[/COLOR] x8 > z8 [COLOR=Royalblue]Then[/COLOR] z8 = x8
            
        [COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]With[/COLOR]
    [COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]If[/COLOR]
[COLOR=Royalblue]Next[/COLOR]

[COLOR=Royalblue]With[/COLOR] Sheets([COLOR=brown]"TEMP"[/COLOR])

.Range([COLOR=brown]"A1"[/COLOR]) = [COLOR=brown]"(DIM 1 DIA)"[/COLOR]
.Range([COLOR=brown]"B1"[/COLOR]) = [COLOR=brown]"(DIM 1 POS)"[/COLOR]
.Range([COLOR=brown]"C1"[/COLOR]) = [COLOR=brown]"(DIM 5 MIN)"[/COLOR]
.Range([COLOR=brown]"D1"[/COLOR]) = [COLOR=brown]"(DIM 5 MAX)"[/COLOR]
.Range([COLOR=brown]"E1"[/COLOR]) = [COLOR=brown]"(DIM 6 MIN)"[/COLOR]
.Range([COLOR=brown]"F1"[/COLOR]) = [COLOR=brown]"(DIM 6 MAX)"[/COLOR]
.Range([COLOR=brown]"G1"[/COLOR]) = [COLOR=brown]"(DIM 8 DIA)"[/COLOR]
.Range([COLOR=brown]"H1"[/COLOR]) = [COLOR=brown]"(DIM 8 POS)"[/COLOR]

.Range([COLOR=brown]"A2"[/COLOR]) = z1
.Range([COLOR=brown]"B2"[/COLOR]) = z2
.Range([COLOR=brown]"C2"[/COLOR]) = z3
.Range([COLOR=brown]"D2"[/COLOR]) = z4
.Range([COLOR=brown]"E2"[/COLOR]) = z5
.Range([COLOR=brown]"F2"[/COLOR]) = z6
.Range([COLOR=brown]"G2"[/COLOR]) = z7
.Range([COLOR=brown]"H2"[/COLOR]) = z8

[COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]With[/COLOR]

    MsgBox [COLOR=brown]"It's done in "[/COLOR] & Timer - t & [COLOR=brown]" seconds"[/COLOR]


[COLOR=Royalblue]End[/COLOR] [COLOR=Royalblue]Sub[/COLOR][/FONT]
Click to expand...

That worked! Thank you so much! It's really amazing to me...I kind of want to buy some books on VBA and start learning how to do this.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
VBA Search box and button code
Replies
0
Views
247
jlcodes
J
V
  • Question Question
Copy Range from Multiple Sheets and Paste Link into a Single Sheet
Replies
2
Views
182
vbascientist
V
Logit
  • Question Question
Search In Other Workbook - Copy/Paste Offset Data To First Workbook - Repeat Process
Replies
7
Views
328
Logit
Logit
C
  • Solved
Extracting data with VBA macro button from files in designated folder
2 3
Replies
20
Views
859
Micron
M
V
  • Question Question
Searching for text in textboxes in Excel
2
Replies
15
Views
508
DanteAmor
DanteAmor

Forum statistics

Threads
1,223,911
Messages
6,175,325
Members
452,635
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top