VBA Help (Range Names, Variables & More)

[Ryan Saari]

I have a calendar setup with five "rows" similar to this one, this being the top:

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD><TD>Q</TD><TD>R</TD><TD>S</TD><TD>T</TD><TD>U</TD><TD>V</TD><TD>W</TD><TD>X</TD><TD>Y</TD><TD>Z</TD><TD>AA</TD><TD>AB</TD><TD>AC</TD><TD>AD</TD><TD>AE</TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt" colSpan=2></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 32pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center" colSpan=28 rowSpan=2>JULY</TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD colSpan=2></TD><TD></TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 8pt" colSpan=2></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center" colSpan=4>SUNDAY</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center" colSpan=4>MONDAY</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center" colSpan=4>TUESDAY</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center" colSpan=4>WEDNESDAY</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center" colSpan=4>THURSDAY</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center" colSpan=4>FRIDAY</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center" colSpan=4>SATURDAY</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">29</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 6.5pt"></TD><TD style="FONT-SIZE: 6pt" colSpan=2></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">30</TD><TD style="FONT-SIZE: 6pt" colSpan=3></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">1</TD><TD style="FONT-SIZE: 6pt" colSpan=3></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">2</TD><TD style="FONT-SIZE: 6pt" colSpan=3></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">3</TD><TD style="FONT-SIZE: 6pt" colSpan=3></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">4</TD><TD style="FONT-SIZE: 6pt"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt" colSpan=2></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">5</TD><TD style="FONT-SIZE: 6pt" colSpan=3></TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff">NAME1</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">37.5 </TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff">NAME2</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">37.5 </TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">4:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman">NAME3</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: left">37.5 </TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman">NAME4</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: left">30.0 </TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">10:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">6:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">AC</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff">NAME5</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">30.0 </TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">4:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">10:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">6:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff">NAME6</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">37.5 </TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">9:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">6:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">AP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center">7.5</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman">NAME7</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: left">30.0 </TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">BP</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman">NAME8</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: left">37.5 </TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">TB</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">TB</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">TB</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">OFF</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">TB</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">8:30</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">TB</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5:00</TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7.5</TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">- </TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">- </TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff"></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: center"></TD></TR><TR style="HEIGHT: 13px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 7pt; FONT-FAMILY: Times New Roman"></TD><TD style="FONT-SIZE: 6pt; FONT-FAMILY: Times New Roman" colSpan=3></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">0</TD><TD style="FONT-SIZE: 6pt; FONT-FAMILY: Times New Roman" colSpan=3></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 6pt; FONT-FAMILY: Times New Roman" colSpan=3></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 6pt; FONT-FAMILY: Times New Roman" colSpan=3></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 6pt; FONT-FAMILY: Times New Roman" colSpan=3></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 6pt; FONT-FAMILY: Times New Roman" colSpan=3></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 6pt; FONT-FAMILY: Times New Roman" colSpan=3></TD><TD style="FONT-SIZE: 6.5pt; FONT-FAMILY: Times New Roman; TEXT-ALIGN: center">5</TD></TR></TBODY></TABLE>

1) On this calendar I would like excel to automatically define a range name for each day of the month. I already have formula in place that when the Month is changed to say September the dates change (all "if" statements).

2) I would like to be able to use a dropdown list of those produced named ranges on sheet2 in say cell A1; then when that dropdown say selects "July 23rd" I would like it to automatically display that named range in say cells C2:G15 of sheet2.

3) I would also like to be able to call up the hours and times that a particular individual worked in that week in a similar fashion.

Even if you cannot help me, if you could give me some search ideas I would really appreciate it. I know quite a bit in the way of formula's but very little VBA so please be patient!

Thank you for your assistance!

Ryan