Need help on printing select rows only each month

[Looking for answers]

Is it possible to either have a macro (I have no idea how to write one) to allow the user to select a print range (the header would need to be included) so that they only get the portion of the worksheet that pertains to them. See the spreadsheet below.




<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial Black,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="HEIGHT: 27px"><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; FONT-FAMILY: Arial; TEXT-ALIGN: center" colSpan=12>HCP Life Science Estates</TD></TR><TR style="HEIGHT: 36px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 16pt; FONT-FAMILY: Arial; TEXT-ALIGN: center" colSpan=12>ANALYSIS ON - PROPERTY TAX</TD></TR><TR style="HEIGHT: 36px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; FONT-FAMILY: Arial; TEXT-ALIGN: center" colSpan=12>April 30, 2010</TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 14pt; FONT-FAMILY: Arial" colSpan=12> </TD></TR><TR style="HEIGHT: 27px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">Period/Payment Info.</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">6911-8010</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1700-2001</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">2130-1001</TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 27px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Property Name / </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">Fiscal</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Payment</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">Monthly </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Expense</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Prepaid</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">A/Payble</TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Proj. No.</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Parcel No</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Total</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">Period</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Month</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Amount</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">4/30/2010</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">4/30/2010</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">4/30/2010</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Comment</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 34px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1400</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">HAYWARD - Point Eden I & II 461-85-29</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 16,640.73 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">01/01/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 2,773.46 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center"> 11,093.82 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 5,546.91 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: left">2010 Taxes First Half</TD></TR><TR style="HEIGHT: 34px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1400</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">HAYWARD - Point Eden I & II 461-85-30</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 41,697.41 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">01/01/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 6,949.57 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center"> 27,798.27 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 13,899.14 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: left">2010 Taxes First Half</TD></TR><TR style="HEIGHT: 34px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1400</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">HAYWARD - Point Eden I & II 461-85-31</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 1,064.53 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">01/01/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 177.42 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center"> 709.69 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 354.84 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: left">2010 Taxes First Half</TD></TR><TR style="HEIGHT: 34px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1400</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">HAYWARD - Point Eden I & II 461-85-34-1</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 1,165.61 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">01/01/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 194.27 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center"> 777.07 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 388.54 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: left">2010 Taxes First Half</TD></TR><TR style="HEIGHT: 34px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1400</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">HAYWARD - Point Eden I & II 461-85-48-1</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 203,588.27 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">01/01/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 33,931.38 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center"> 135,725.51 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 67,862.76 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: left">2010 Taxes First Half</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-STYLE: italic; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">TOTAL:</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">264,156.55 </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-STYLE: italic; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">TOTAL:</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">44,026.10 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">176,104.36 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">88,052.19 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">0.00 </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">General Ledger Balance</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 176,104.37 </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 88,052.18 </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 11pt; FONT-FAMILY: Times New Roman">Difference</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> (0.01)</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 0.01 </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 27px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">Period/Payment Info.</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">6911-8010</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1700-2001</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">2130-1001</TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 27px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Property Name / </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">Fiscal</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Payment</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">Monthly </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Expense</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Prepaid</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">A/Payble</TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Proj. No.</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Parcel No</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Total</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">Period</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Month</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Amount</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">4/30/2010</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">4/30/2010</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">4/30/2010</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">Comment</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 34px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1401</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">HAYWARD - Point Eden III 461-85-29</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 1,701.21 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">01/01/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 283.54 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center"> 1,134.14 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 567.07 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: left">2010 Taxes First Half</TD></TR><TR style="HEIGHT: 34px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1401</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">HAYWARD - Point Eden III 461-85-30</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 4,262.80 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">01/01/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 710.47 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center"> 2,841.87 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 1,420.93 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: left">2010 Taxes First Half</TD></TR><TR style="HEIGHT: 34px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1401</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">HAYWARD - Point Eden III 461-85-31</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 108.83 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">01/01/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 18.14 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center"> 72.55 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 36.28 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: left">2010 Taxes First Half</TD></TR><TR style="HEIGHT: 34px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1401</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">HAYWARD - Point Eden III 461-85-34-1</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 119.16 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">01/01/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 19.86 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center"> 79.44 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 39.72 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: left">2010 Taxes First Half</TD></TR><TR style="HEIGHT: 34px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">1401</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">HAYWARD - Point Eden III 461-85-48-1</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 20,813.18 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">01/01/10</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center">06/30/10</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 3,468.86 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: center"> 13,875.45 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 6,937.73 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: left">2010 Taxes First Half</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-STYLE: italic; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">TOTAL:</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">27,005.18 </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-STYLE: italic; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">TOTAL:</TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">4,500.87 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">18,003.45 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">9,001.73 </TD><TD style="FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right">0.00 </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-SIZE: 8.5pt; FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">33</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif">General Ledger Balance</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 18,003.46 </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 9,001.72 </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">34</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 11pt; FONT-FAMILY: Times New Roman">Difference</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> (0.01)</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> 0.01 </TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: MS Sans Serif; TEXT-ALIGN: right"> - </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">35</TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD><TD style="FONT-FAMILY: MS Sans Serif"> </TD></TR></TBODY></TABLE>

For example:

Rows 1-4 are the header rows and would need to print on all pages.

Rows to print would be 21-31

ALso would it be possible to do this for various print ranges at one the spreadsheet is over 100 rows with about 75 different project numbers.

I tried to use a filter but was not very successful

Any help would be appreciated

Thanks

 

[jbeaucaire]

Sorry, that was an earlier variable I used and took out in the final version. Just delete the line of code:

Set PrintRNG = Nothing

 

[Looking for answers]

Thank you for that it took care of the error, however I now have a new problem.

When the message box pops up asking me to select the rows I can not select any row (I have the hourglass as my cursor) if I click on the ok button the macro completes without printing anything

any thoughts on this, am I doing something wrong??

Thank you

 

[jbeaucaire]

When you see that message, click OK to end the macro.

Make a selection of rows in column A.

Run the macro again.

 

[Looking for answers]

Thank you for that information

It works real nice thank you