VBA Code Not Working / Error - Hide rows depending on 2x drop down lists

tlc53

tlc53

Active Member
Joined
Jul 26, 2018
Messages
399
Hi there,

Before I go back to the drawing board, can anyone see whether they can get this VBA code to work?

Basically, I have two drop down lists. One is "No. of Investments" and the other is "No. of Partners". I would like certain rows to hide, depending on the result of both drop down lists.

Each case below shows the change in "No. of Investments" and then looks at the drop down list of "No. of Partners" and hides the rows accordingly (well, it's supposed to atleast).

Often, drop down list "No. of Partners" will not be engaged and will remain on "Please Select", so the first line of code will be used depending on the "No. of Investments" selected.

Currently the error being returned is "Compile Error - Argument no Optional" and it highlights the word "Union" on the first "Set R" line.

Drop down lists look like this;
No._Investments = Please Select,0,2,4,6,8,10
No._Partners = Please Select,2,3,4,5,6,7,8,9,10

Thanks for looking.


Code: 
Private Sub Worksheet_Change(ByVal Target As Range)


Dim i As Range
  Dim R As Range
  Dim InvSel As Integer
  Dim PartSel As Integer
  Dim InvestRng As Range
  Dim PartnerRng As Range
  
  Set InvestRng = Range("No._Investments")
  Set PartnerRng = Range("No._Partners")
  
  Set i = Intersect(Target, InvestRng)
  If Not i Is Nothing Then
    InvSel = InvestRng.Value
    PartSel = PartnerRng.Value
    Select Case InvSel
      Case "Please Select"
        If PartSel = "Please Select" Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 2 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 3 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 4 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 5 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 6 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 7 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 8 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 9 Then
          Set R = Union(Range("163:292"))
        End If
     Case 0
        If PartSel = "Please Select" Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 2 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 3 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 4 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 5 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 6 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 7 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 8 Then
          Set R = Union(Range("163:292"))
        ElseIf PartSel = 9 Then
          Set R = Union(Range("163:292"))
        End If
      Case 2
        If PartSel = "Please Select" Then
          Set R = Union(Range("165:173"), Range("178:186"))
        ElseIf PartSel = 2 Then
          Set R = Union(Range("166:173"), Range("179:186"))
        ElseIf PartSel = 3 Then
          Set R = Union(Range("167:173"), Range("180:186"))
        ElseIf PartSel = 4 Then
          Set R = Union(Range("168:173"), Range("181:186"))
        ElseIf PartSel = 5 Then
          Set R = Union(Range("169:173"), Range("182:186"))
        ElseIf PartSel = 6 Then
          Set R = Union(Range("170:173"), Range("183:186"))
        ElseIf PartSel = 7 Then
          Set R = Union(Range("171:173"), Range("184:186"))
        ElseIf PartSel = 8 Then
          Set R = Union(Range("172:173"), Range("185:186"))
        ElseIf PartSel = 9 Then
          Set R = Union(Range("173"), Range("186"))
        End If
      
      Case 4
        If PartSel = "Please Select" Then
          Set R = Union(Range("165:173"), Range("178:186"), Range("191:199"), Range("204:212"))
        ElseIf PartSel = 2 Then
          Set R = Union(Range("166:173"), Range("179:186"), Range("192:199"), Range("205:212"))
        ElseIf PartSel = 3 Then
          Set R = Union(Range("167:173"), Range("180:186"), Range("193:199"), Range("206:212"))
        ElseIf PartSel = 4 Then
          Set R = Union(Range("168:173"), Range("181:186"), Range("194:199"), Range("207:212"))
        ElseIf PartSel = 5 Then
          Set R = Union(Range("169:173"), Range("182:186"), Range("195:199"), Range("208:212"))
        ElseIf PartSel = 6 Then
          Set R = Union(Range("170:173"), Range("183:186"), Range("196:199"), Range("209:212"))
        ElseIf PartSel = 7 Then
          Set R = Union(Range("171:173"), Range("184:186"), Range("197:199"), Range("210:212"))
        ElseIf PartSel = 8 Then
          Set R = Union(Range("172:173"), Range("185:186"), Range("198:199"), Range("211:212"))
        ElseIf PartSel = 9 Then
          Set R = Union(Range("173"), Range("186"), Range("199"), Range("212"))
        End If
      Case 6
        If PartSel = "Please Select" Then
          Set R = Union(Range("165:173"), Range("178:186"), Range("191:199"), Range("204:212"), Range("217:225"), Range("230:238"))
        ElseIf PartSel = 2 Then
          Set R = Union(Range("166:173"), Range("179:186"), Range("192:199"), Range("205:212"), Range("218:225"), Range("231:238"))
        ElseIf PartSel = 3 Then
          Set R = Union(Range("167:173"), Range("180:186"), Range("193:199"), Range("206:212"), Range("219:225"), Range("232:238"))
        ElseIf PartSel = 4 Then
          Set R = Union(Range("168:173"), Range("181:186"), Range("194:199"), Range("207:212"), Range("220:225"), Range("233:238"))
        ElseIf PartSel = 5 Then
          Set R = Union(Range("169:173"), Range("182:186"), Range("195:199"), Range("208:212"), Range("221:225"), Range("234:238"))
        ElseIf PartSel = 6 Then
          Set R = Union(Range("170:173"), Range("183:186"), Range("196:199"), Range("209:212"), Range("222:225"), Range("235:238"))
        ElseIf PartSel = 7 Then
          Set R = Union(Range("171:173"), Range("184:186"), Range("197:199"), Range("210:212"), Range("223:225"), Range("236:238"))
        ElseIf PartSel = 8 Then
          Set R = Union(Range("172:173"), Range("185:186"), Range("198:199"), Range("211:212"), Range("224:225"), Range("237:238"))
        ElseIf PartSel = 9 Then
          Set R = Union(Range("173"), Range("186"), Range("199"), Range("212"), Range("225"), Range("238"))
        End If
      Case 8
        If PartSel = "Please Select" Then
          Set R = Union(Range("165:173"), Range("178:186"), Range("191:199"), Range("204:212"), Range("217:225"), Range("230:238"), Range("243:251"), Range("256:264"))
        ElseIf PartSel = 2 Then
          Set R = Union(Range("166:173"), Range("179:186"), Range("192:199"), Range("205:212"), Range("218:225"), Range("231:238"), Range("244:251"), Range("257:264"))
        ElseIf PartSel = 3 Then
          Set R = Union(Range("167:173"), Range("180:186"), Range("193:199"), Range("206:212"), Range("219:225"), Range("232:238"), Range("245:251"), Range("258:264"))
        ElseIf PartSel = 4 Then
          Set R = Union(Range("168:173"), Range("181:186"), Range("194:199"), Range("207:212"), Range("220:225"), Range("233:238"), Range("246:251"), Range("259:264"))
        ElseIf PartSel = 5 Then
          Set R = Union(Range("169:173"), Range("182:186"), Range("195:199"), Range("208:212"), Range("221:225"), Range("234:238"), Range("247:251"), Range("260:264"))
        ElseIf PartSel = 6 Then
          Set R = Union(Range("170:173"), Range("183:186"), Range("196:199"), Range("209:212"), Range("222:225"), Range("235:238"), Range("248:251"), Range("261:264"))
        ElseIf PartSel = 7 Then
          Set R = Union(Range("171:173"), Range("184:186"), Range("197:199"), Range("210:212"), Range("223:225"), Range("236:238"), Range("249:251"), Range("262:264"))
        ElseIf PartSel = 8 Then
          Set R = Union(Range("172:173"), Range("185:186"), Range("198:199"), Range("211:212"), Range("224:225"), Range("237:238"), Range("250:251"), Range("263:264"))
        ElseIf PartSel = 9 Then
          Set R = Union(Range("173"), Range("186"), Range("199"), Range("212"), Range("225"), Range("238"), Range("251"), Range("264"))
        End If
      Case 10
        If PartSel = "Please Select" Then
          Set R = Union(Range("165:173"), Range("178:186"), Range("191:199"), Range("204:212"), Range("217:225"), Range("230:238"), Range("243:251"), Range("256:264"), Range("269:277"), Range("282:290"))
        ElseIf PartSel = 2 Then
          Set R = Union(Range("166:173"), Range("179:186"), Range("192:199"), Range("205:212"), Range("218:225"), Range("231:238"), Range("244:251"), Range("257:264"), Range("270:277"), Range("283:290"))
        ElseIf PartSel = 3 Then
          Set R = Union(Range("167:173"), Range("180:186"), Range("193:199"), Range("206:212"), Range("219:225"), Range("231:238"), Range("245:251"), Range("258:264"), Range("271:277"), Range("284:290"))
        ElseIf PartSel = 4 Then
          Set R = Union(Range("168:173"), Range("181:186"), Range("194:199"), Range("207:212"), Range("220:225"), Range("231:238"), Range("246:251"), Range("259:264"), Range("272:277"), Range("285:290"))
        ElseIf PartSel = 5 Then
          Set R = Union(Range("169:173"), Range("182:186"), Range("195:199"), Range("208:212"), Range("221:225"), Range("231:238"), Range("247:251"), Range("260:264"), Range("273:277"), Range("286:290"))
        ElseIf PartSel = 6 Then
          Set R = Union(Range("170:173"), Range("183:186"), Range("196:199"), Range("209:212"), Range("222:225"), Range("231:238"), Range("248:251"), Range("261:264"), Range("274:277"), Range("287:290"))
        ElseIf PartSel = 7 Then
          Set R = Union(Range("171:173"), Range("184:186"), Range("197:199"), Range("210:212"), Range("223:225"), Range("231:238"), Range("249:251"), Range("262:264"), Range("275:277"), Range("288:290"))
        ElseIf PartSel = 8 Then
          Set R = Union(Range("172:173"), Range("185:186"), Range("198:199"), Range("211:212"), Range("224:225"), Range("231:238"), Range("250:251"), Range("263:264"), Range("276:277"), Range("289:290"))
        ElseIf PartSel = 9 Then
          Set R = Union(Range("173"), Range("186"), Range("199"), Range("212"), Range("225"), Range("238"), Range("251"), Range("264"), Range("277"), Range("290"))
     End If
    End Select
      
    If Not R Is Nothing Then R.EntireRow.Hidden = True
  End If
       
          
If [h7] = "YES" Then
Sheets("K1a").Visible = True
Else
Sheets("K1a").Visible = False
End If
End Sub
 
Sort by date Sort by votes
Try this. The line in blue must be modified

DanteAmor said:
Try this

Code: 
Private Sub Worksheet_Change(ByVal Target As Range)


    Dim InvSel As Variant, PartSel As Variant, part1 As Variant, part2 As Variant
    Dim InvestRng As Range, PartnerRng As Range, r As Range, twoRng As Range
    Dim waum As Long, ini1 As Long, fin1 As Long, k As Long
    
    If Target.Count > 2 Then Exit Sub
    
    Set InvestRng = Range("No._Investments")
    Set PartnerRng = Range("No._Partners")
    Set twoRng = Union(InvestRng, PartnerRng)
    If Not Intersect(Target, twoRng) Is Nothing Then
    
        Rows("163:292").EntireRow.Hidden = False
        part1 = Array(163, , 165, , 191, , 217, , 243, , 269)
        part2 = Array(292, , 173, , 199, , 225, , 251, , 277)
        
        InvSel = IIf(InvestRng.Value = "Please Select", 0, InvestRng.Value)
        PartSel = PartnerRng.Value
        If InvSel = 0 Then
            Set r = Range(part1(0) & ":" & part2(0))
        Else
            For k = 2 To InvSel Step 2
                If PartSel = "Please Select" Then waum = 0 Else waum = PartSel - 1
                ini1 = part1(k) + waum
                fin1 = part2(k)
[COLOR=#0000ff]                If fin1 >[/COLOR][SIZE=3][COLOR=#ff0000][B]=[/B][/COLOR][/SIZE][COLOR=#0000ff] ini1 Then[/COLOR]
                    If r Is Nothing Then
                        Set r = Union(Range(ini1 & ":" & fin1), Range(ini1 + 13 & ":" & fin1 + 13))
                    Else
                        Set r = Union(r, Range(ini1 & ":" & fin1), Range(ini1 + 13 & ":" & fin1 + 13))
                    End If
                End If
            Next
        End If
        
        If Not r Is Nothing Then r.EntireRow.Hidden = True
    End If
    
    If [h7] = "YES" Then
        Sheets("K1a").Visible = True
    Else
        Sheets("K1a").Visible = False
    End If
End Sub
Click to expand...
 
Upvote 0

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Hi Dante. I really appreciate you taking the time to look at this code again.
It is not from lack of trying on my side but I just can't seem to get it to behave correctly. I read your notes carefully and tried changing numerous things, but the best I can do, is to get it working on even numbers only.
You'll see I have put in all numbers from 1-10 under Investments and placed conditional formatting to hide sections which are not required (for example 3 selected, conditional formatting hides number 4).
Also, under the journal section, it is hiding rows 295:304 which doesn't even come into play.
Would you mind taking a look please??? If I have to work with even numbers only, I will, but it would be great if it could work on all investment numbers. Thank you!!

https://www.dropbox.com/s/r65pssyxpuy6b0o/K1 re Investment - Dante.xlsm?dl=0
 
Upvote 0
I will try to review, but there are more than 80 tests to perform, I do not have the time to try everything, so I only review some of them and they work.
 
Upvote 0
I tried adding to the arrays so it covered all investments numbers (even and odd) but that didn't do the trick.

Rows("163:292").EntireRow.Hidden = False
part1 = Array(163, 165, 178, 191, 204, 217, 230, 243, 256, 269, 282)
part2 = Array(292, 173, 186, 199, 212, 225, 238, 251, 264, 277, 290)

Sorry, I hadn't realised it was so in-depth. If you don't get the time, don't worry about it, I'll just go back to using even numbers.
 
Upvote 0
You can give me all the combinations and which rows should be hidden.
0-0 - what rows are hidden
0-2 - what rows are hidden
0-3 - what rows are hidden
...
2-0 - what rows are hidden
2-2 - what rows are hidden
2-3 - what rows are hidden
2-4- what rows are hidden
...
4-0 - what rows are hidden
4-2 - what rows are hidden
4-3 - what rows are hidden
4-4- what rows are hidden
...
and continue
.


Do you have other macros running?
 
Upvote 0
I now totally appreciate what you mean by many tests to run! Below is the detail of the rows which should hide depending on the combined outcome of Investment and Partner.
I have other VBA coding which hides/unhides rows above the journal section depending on Investment selection and another for Partner selection. I also have VBA coding on this sheet which hides/unhides another sheet (K1a) depending on another drop down selection. The picture icon at the top left hand corner takes you to the Home Page sheet.
Eventually, there will be a Posting Macro which will take the final journal figures (B157:M292) and paste them onto another sheet. There are also macros on other sheets within the workbook.
Thank you!

Code: 
[TABLE="width: 755"]
<tbody>[TR]
[TD]Investment[/TD]
[TD]Partner[/TD]
[TD="colspan: 2"]Rows Hidden[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Please Select[/TD]
[TD]*All[/TD]
[TD]163:292[/TD]
[TD]176:292[/TD]
[TD="colspan: 4"]*All includes: Please Select, 2-10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD]*All[/TD]
[TD]163:292[/TD]
[TD]176:292[/TD]
[TD="colspan: 4"]*All includes: Please Select, 2-10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]0[/TD]
[TD]165:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]231:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]232:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]233:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]234:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]235:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]236:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]237:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]238:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]231:238[/TD]
[TD]244:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]232:238[/TD]
[TD]245:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]233:238[/TD]
[TD]246:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]234:238[/TD]
[TD]247:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]235:238[/TD]
[TD]248:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]236:238[/TD]
[TD]249:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]237:238[/TD]
[TD]250:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]238:238[/TD]
[TD]251:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]254:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]256:264[/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]256:264[/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]231:238[/TD]
[TD]244:251[/TD]
[TD]257:264[/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]232:238[/TD]
[TD]245:251[/TD]
[TD]258:264[/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]233:238[/TD]
[TD]246:251[/TD]
[TD]259:264[/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]234:238[/TD]
[TD]247:251[/TD]
[TD]260:264[/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]235:238[/TD]
[TD]248:251[/TD]
[TD]261:264[/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]236:238[/TD]
[TD]249:251[/TD]
[TD]262:264[/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]237:238[/TD]
[TD]250:251[/TD]
[TD]262:264[/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]238:238[/TD]
[TD]251:251[/TD]
[TD]264:264[/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]267:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]269:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]269:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]231:238[/TD]
[TD]244:251[/TD]
[TD]270:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]232:238[/TD]
[TD]245:251[/TD]
[TD]271:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]233:238[/TD]
[TD]246:251[/TD]
[TD]272:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]234:238[/TD]
[TD]247:251[/TD]
[TD]273:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]235:238[/TD]
[TD]248:251[/TD]
[TD]274:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]236:238[/TD]
[TD]249:251[/TD]
[TD]275:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]237:238[/TD]
[TD]250:251[/TD]
[TD]276:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]238:238[/TD]
[TD]251:251[/TD]
[TD]277:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]269:277[/TD]
[TD]282:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]269:277[/TD]
[TD]282:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]231:238[/TD]
[TD]244:251[/TD]
[TD]270:277[/TD]
[TD]283:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]232:238[/TD]
[TD]245:251[/TD]
[TD]271:277[/TD]
[TD]284:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]233:238[/TD]
[TD]246:251[/TD]
[TD]272:277[/TD]
[TD]285:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]234:238[/TD]
[TD]247:251[/TD]
[TD]273:277[/TD]
[TD]286:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]235:238[/TD]
[TD]248:251[/TD]
[TD]274:277[/TD]
[TD]287:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]236:238[/TD]
[TD]249:251[/TD]
[TD]275:277[/TD]
[TD]288:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]237:238[/TD]
[TD]250:251[/TD]
[TD]276:277[/TD]
[TD]289:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]238:238[/TD]
[TD]251:251[/TD]
[TD]277:277[/TD]
[TD]290:290[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
I just noticed Investment 10, Partner 10 dropped off the end. If selected, no rows to hide.
 
Upvote 0
Sorry!! I just realised I omitted two sections from 9 and 10. Revised/correct below..

Code: 
[TABLE="width: 819"]
<tbody>[TR]
[TD]Investment[/TD]
[TD]Partner[/TD]
[TD="colspan: 2"]Rows Hidden[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Please Select[/TD]
[TD]*All[/TD]
[TD]163:292[/TD]
[TD]176:292[/TD]
[TD="colspan: 4"]*All includes: Please Select, 2-10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD]*All[/TD]
[TD]163:292[/TD]
[TD]176:292[/TD]
[TD="colspan: 4"]*All includes: Please Select, 2-10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]0[/TD]
[TD]165:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD]176:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]189:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]202:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]215:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]228:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]231:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]232:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]233:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]234:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]235:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]236:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]237:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]238:238[/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]241:292[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]231:238[/TD]
[TD]244:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]232:238[/TD]
[TD]245:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]233:238[/TD]
[TD]246:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]234:238[/TD]
[TD]247:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]235:238[/TD]
[TD]248:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]236:238[/TD]
[TD]249:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]237:238[/TD]
[TD]250:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]238:238[/TD]
[TD]251:251[/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]254:292[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]256:264[/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]256:264[/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]231:238[/TD]
[TD]244:251[/TD]
[TD]257:264[/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]232:238[/TD]
[TD]245:251[/TD]
[TD]258:264[/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]233:238[/TD]
[TD]246:251[/TD]
[TD]259:264[/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]234:238[/TD]
[TD]247:251[/TD]
[TD]260:264[/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]235:238[/TD]
[TD]248:251[/TD]
[TD]261:264[/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]236:238[/TD]
[TD]249:251[/TD]
[TD]262:264[/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]237:238[/TD]
[TD]250:251[/TD]
[TD]262:264[/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]238:238[/TD]
[TD]251:251[/TD]
[TD]264:264[/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]267:292[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]256:264[/TD]
[TD]269:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]256:264[/TD]
[TD]269:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]231:238[/TD]
[TD]244:251[/TD]
[TD]257:264[/TD]
[TD]270:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]232:238[/TD]
[TD]245:251[/TD]
[TD]258:264[/TD]
[TD]271:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]233:238[/TD]
[TD]246:251[/TD]
[TD]259:264[/TD]
[TD]272:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]234:238[/TD]
[TD]247:251[/TD]
[TD]260:264[/TD]
[TD]273:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]235:238[/TD]
[TD]248:251[/TD]
[TD]261:264[/TD]
[TD]274:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]236:238[/TD]
[TD]249:251[/TD]
[TD]262:264[/TD]
[TD]275:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]237:238[/TD]
[TD]250:251[/TD]
[TD]262:264[/TD]
[TD]276:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]238:238[/TD]
[TD]251:251[/TD]
[TD]264:264[/TD]
[TD]277:277[/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]280:292[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]Please Select[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]256:264[/TD]
[TD]269:277[/TD]
[TD]282:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD]165:173[/TD]
[TD]178:186[/TD]
[TD]191:199[/TD]
[TD]204:212[/TD]
[TD]217:225[/TD]
[TD]230:238[/TD]
[TD]243:251[/TD]
[TD]256:264[/TD]
[TD]269:277[/TD]
[TD]282:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD]166:173[/TD]
[TD]179:186[/TD]
[TD]192:199[/TD]
[TD]205:212[/TD]
[TD]218:225[/TD]
[TD]231:238[/TD]
[TD]244:251[/TD]
[TD]257:264[/TD]
[TD]270:277[/TD]
[TD]283:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD]167:173[/TD]
[TD]180:186[/TD]
[TD]193:199[/TD]
[TD]206:212[/TD]
[TD]219:225[/TD]
[TD]232:238[/TD]
[TD]245:251[/TD]
[TD]258:264[/TD]
[TD]271:277[/TD]
[TD]284:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD]168:173[/TD]
[TD]181:186[/TD]
[TD]194:199[/TD]
[TD]207:212[/TD]
[TD]220:225[/TD]
[TD]233:238[/TD]
[TD]246:251[/TD]
[TD]259:264[/TD]
[TD]272:277[/TD]
[TD]285:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD]169:173[/TD]
[TD]182:186[/TD]
[TD]195:199[/TD]
[TD]208:212[/TD]
[TD]221:225[/TD]
[TD]234:238[/TD]
[TD]247:251[/TD]
[TD]260:264[/TD]
[TD]273:277[/TD]
[TD]286:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]6[/TD]
[TD]170:173[/TD]
[TD]183:186[/TD]
[TD]196:199[/TD]
[TD]209:212[/TD]
[TD]222:225[/TD]
[TD]235:238[/TD]
[TD]248:251[/TD]
[TD]261:264[/TD]
[TD]274:277[/TD]
[TD]287:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]7[/TD]
[TD]171:173[/TD]
[TD]184:186[/TD]
[TD]197:199[/TD]
[TD]210:212[/TD]
[TD]223:225[/TD]
[TD]236:238[/TD]
[TD]249:251[/TD]
[TD]262:264[/TD]
[TD]275:277[/TD]
[TD]288:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]8[/TD]
[TD]172:173[/TD]
[TD]185:186[/TD]
[TD]198:199[/TD]
[TD]211:212[/TD]
[TD]224:225[/TD]
[TD]237:238[/TD]
[TD]250:251[/TD]
[TD]262:264[/TD]
[TD]276:277[/TD]
[TD]289:290[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]9[/TD]
[TD]173:173[/TD]
[TD]186:186[/TD]
[TD]199:199[/TD]
[TD]212:212[/TD]
[TD]225:225[/TD]
[TD]238:238[/TD]
[TD]251:251[/TD]
[TD]264:264[/TD]
[TD]277:277[/TD]
[TD]290:290[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Do you have a macro that hides rows?


I have other VBA coding which hides / unhides rows above the journal section depending on Investment selection and another for Partner selection.
Click to expand...


Could you remove that macro and only test my macro and tell me where the fault is?
 
Upvote 0
Your previous code with even numbers works the best for me, so I have decided to go back to that.
However, is it easy enough that if investment 1 is selected, settings for investment 2 is applied.
Eg.
Investment
1 or 2 - applies No.2 settings
3 or 4 - applies No.4 setting
5 or 6 - applies No.6 settings
7 or 8 - applies No.8 settings
9 or 10 - applies No.10 settings

Just so the user can choose an odd number of investments, even though the even number settings/visibility are applied. If not easy, don't worry!!

I'm going back to using this code..

Code: 
Private Sub Worksheet_Change(ByVal Target As Range)




    Dim InvSel As Variant, PartSel As Variant, part1 As Variant, part2 As Variant
    Dim InvestRng As Range, PartnerRng As Range, r As Range, twoRng As Range
    Dim waum As Long, ini1 As Long, fin1 As Long, k As Long
    
    If Target.Count > 2 Then Exit Sub
    
    Set InvestRng = Range("No._Investments")
    Set PartnerRng = Range("No._Partners")
    Set twoRng = Union(InvestRng, PartnerRng)
    If Not Intersect(Target, twoRng) Is Nothing Then
    
        Rows("163:292").EntireRow.Hidden = False
        part1 = Array(163, , 165, , 191, , 217, , 243, , 269)
        part2 = Array(292, , 173, , 199, , 225, , 251, , 277)
        
        InvSel = IIf(InvestRng.Value = "Please Select", 0, InvestRng.Value)
        PartSel = PartnerRng.Value
        If InvSel = 0 Then
            Set r = Range(part1(0) & ":" & part2(0))
        Else
            For k = 2 To InvSel Step 2
                If PartSel = "Please Select" Then waum = 0 Else waum = PartSel - 1
                ini1 = part1(k) + waum
                fin1 = part2(k)
                If fin1 > ini1 Then
                    If r Is Nothing Then
                        Set r = Union(Range(ini1 & ":" & fin1), Range(ini1 + 13 & ":" & fin1 + 13))
                    Else
                        Set r = Union(r, Range(ini1 & ":" & fin1), Range(ini1 + 13 & ":" & fin1 + 13))
                    End If
                End If
            Next
        End If
        
        If Not r Is Nothing Then r.EntireRow.Hidden = True
    End If
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
VBA Find Cell from Date listed, in Columns, Return cell to highlight in color
Replies
7
Views
532
mumps
mumps
C
  • Question Question
Excel Formula to keep records of drawn cards
Replies
3
Views
297
Cquake
C
M
  • Solved
HELP---- Count Cells in a row based on Month and Unique cell contents.
2
Replies
16
Views
608
Peter_SSs
Peter_SSs
A
  • Question Question
Data Selection Based on Closest Value [20% Tolerance]
Replies
1
Views
210
StephenCrump
S
J
  • Solved
how to random all numbers
Replies
7
Views
280
Fluff
Fluff

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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