I'm at my wits end trying to figure out what is wrong! I'm new at excel vba and new at forums so please have patience!
I keep receiving Run Time Error "Could Not Set The Value Property:Type Mismatch" in the last line of code. My Input values show up fine but it seems the Index is not looking up the values.
This works fine in the worksheet:
=(INDEX(B2:M53,MATCH(Q17,B1:M1,0),MATCH(Q18,A2:A53,0)))
Private Sub txtUiMulti_Exit(ByVal cancel As MSForms.ReturnBoolean)
'Returns United Inch multiplier from UI Table
Dim Input1 As Long
Dim Input2 As Integer
Dim ws As Worksheet
Set ws = Worksheets("UnitedInch")
Worksheets("UnitedInch").Activate
'Gets the frame width from userform, compares to top row of table
Input1 = txtFrameWidth1.Value
'Gets total united inches from userform, compares to 1st column of table
Input2 = txtUnitedInchTotal.Value
'Should return a value from A2:M53
txtUiMulti.Value = Application.index(("B2:M53"), Application.Match(Input1, ("B1:M1"), 0), Application.Match(Input2, ("A2:A53"), 0))
End Sub
Here is a sample of the table it runs 53 rows:
<TABLE style="WIDTH: 624pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=832><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" span=12 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl63 height=20 width=64></TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>0.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>1</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>1.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>2</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>2.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>3</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>3.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>4</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>4.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>5.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>6</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>12</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>14</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>16</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>18</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.67</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>20</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>8.00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>22</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>8.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>8.00</TD></TR></TBODY></TABLE>
I keep receiving Run Time Error "Could Not Set The Value Property:Type Mismatch" in the last line of code. My Input values show up fine but it seems the Index is not looking up the values.
This works fine in the worksheet:
=(INDEX(B2:M53,MATCH(Q17,B1:M1,0),MATCH(Q18,A2:A53,0)))
Private Sub txtUiMulti_Exit(ByVal cancel As MSForms.ReturnBoolean)
'Returns United Inch multiplier from UI Table
Dim Input1 As Long
Dim Input2 As Integer
Dim ws As Worksheet
Set ws = Worksheets("UnitedInch")
Worksheets("UnitedInch").Activate
'Gets the frame width from userform, compares to top row of table
Input1 = txtFrameWidth1.Value
'Gets total united inches from userform, compares to 1st column of table
Input2 = txtUnitedInchTotal.Value
'Should return a value from A2:M53
txtUiMulti.Value = Application.index(("B2:M53"), Application.Match(Input1, ("B1:M1"), 0), Application.Match(Input2, ("A2:A53"), 0))
End Sub
Here is a sample of the table it runs 53 rows:
<TABLE style="WIDTH: 624pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=832><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" span=12 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl63 height=20 width=64></TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>0.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>1</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>1.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>2</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>2.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>3</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>3.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>4</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>4.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>5.5</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl65 width=64>6</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>12</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>14</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>16</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>3.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>18</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.67</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>20</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>8.00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl64 height=20 width=64>22</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>4.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>5.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>6.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>7.67</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>8.00</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ffffff; BACKGROUND-COLOR: #fffbf0; WIDTH: 48pt; BORDER-TOP: #ffffff; BORDER-RIGHT: black 1pt solid" class=xl66 width=64>8.00</TD></TR></TBODY></TABLE>