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]

In the Page Setup > Sheet > Rows to Repeat put $1:$4

Then select the range you want to print, Ctrl-P, click on [x] Selection.

 

[Looking for answers]

Thanks for the response

I did set the header rows already, what i was hoping for was a quicker way then selecting the indiviual pront rannges as this would need to be done 75 times each month

Thanks

 

[Looking for answers]

Does anyone know of a way to write a macro that will allow a user to select the print area and have it include the row set as header rows.

Any help is appreciated

 

[jbeaucaire]

If you can logically describe the consistent manner in which you would go through your worksheet and select sections to print, a macro can mimic your logic. We know how to write the macros, but we don't have your insight as to how you evaluate your worksheet.

So we'll need all that logic and or a sample workbook posted somewhere we can look at together...that would get it right the first time.

 

[Looking for answers]

In the example above I am only showing two sections on the worksheet there are about 75 different sections.

To simplfy the process the header rows will be 1-7. This would elimante the need for the three rows with the property information (for example rows 5-7 would now be apart of the header) and rows 23-25 would be deleted as unnecessary.

The user needs to be able to print there section which in the example would be rows 8-17 or 24-29 (there are many other sections) right know the user is hiding all of the rows that are not a part of the section they want to print, then unhiding the rows and rehiding to print another section and so on.

I am hoping there is a way to have a macro know that rows 1-7 are the headers and should always be printed, then allow the user to enter by either typing the start and ending rows or by selecting the rows using the mouse to select the rows.

This would make it easier and more efficient way to print the individual sections.

Thank you

 

[jbeaucaire]

There's a cool "areas" function in VBA that might be useful here.

1) Are the "Sections" where there are project numbers in column A, are those always 5 rows deep?

2) However long each project area is, is it always the following 5 rows to be added to make the section complete? For instance, the first column A "area" is A9:A13...so if we add 5 to that we have A9:A18 and now have enough rows to cover the whole "section".

3) You're going to set you PageSetup for this page to repeat rows 1:7 at the top of each printed page, so we just need a macro to find all the "areas" you have selected in column A, we can probably take it from there.

4) The simplest would probably be to print each section as a print job.

 

[Looking for answers]

1) Are the "Sections" where there are project numbers in column A, are those always 5 rows deep?

No they will vary from 1-5 rows of information (we can make all sections the same number of rows if this helps, it will also make each report the same size.

2) However long each project area is, is it always the following 5 rows to be added to make the section complete? For instance, the first column A "area" is A9:A13...so if we add 5 to that we have A9:A18 and now have enough rows to cover the whole "section".

We can make each section similar in size

3) You're going to set you PageSetup for this page to repeat rows 1:7 at the top of each printed page, so we just need a macro to find all the "areas" you have selected in column A, we can probably take it from there.

This has been done

4) The simplest would probably be to print each section as a print job.

I am not sure how this is done and most of the users are beginners as well.

Thank you

 

[jbeaucaire]

In the workbook, remove all the "headers" from each section and include it in rows 5:7 as you had already indicated you would do. If you select A8, then Window > FreezePanes you will be able to see those rows all the time.

Then put your other data in normally. Like this for instance:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	HCP Life Science Estates
2	ANALYSIS ON PROPERTY TAX
3	30-Apr-10
4
5				Period/Payment Info.					6911-8010	1700-2001	2130-1001
6		Property Name /		Fiscal			Payment	Monthly	Expense	Prepaid	A/Payble
7	Proj. No.	Parcel No	Total	Period			Month	Amount	4/30/2010	4/30/2010	4/30/2010	Comment
8
9	1400	HAYWARD - Point Eden I & II 461-85-29	16,640.73	1/1/2010		6/30/2010		2,773.46	11,093.82	5,546.91	-	2010 Taxes First Half
10	1400	HAYWARD - Point Eden I & II 461-85-30	41,697.41	1/1/2010		6/30/2010		6,949.57	27,798.27	13,899.14	-	2010 Taxes First Half
11	1400	HAYWARD - Point Eden I & II 461-85-31	1,064.53	1/1/2010		6/30/2010		177.42	709.69	354.84	-	2010 Taxes First Half
12	1400	HAYWARD - Point Eden I & II 461-85-34-1	1,165.61	1/1/2010		6/30/2010		194.27	777.07	388.54	-	2010 Taxes First Half
13	1400	HAYWARD - Point Eden I & II 461-85-48-1	203,588.27	1/1/2010		6/30/2010		33,931.38	135,725.51	67,862.76	-	2010 Taxes First Half
14
15		TOTAL:	264,156.55				TOTAL:	44,026.10	176,104.36	88,052.19	0
16
17		General Ledger Balance							176,104.37	88,052.18	-
18		Difference							-0.01	0.01	-
19
20
21
22	1401	HAYWARD - Point Eden III 461-85-29	1,701.21	1/1/2010		6/30/2010	6/30/2010	283.54	1,134.14	567.07	-	2010 Taxes First Half
23	1401	HAYWARD - Point Eden III 461-85-30	4,262.80	1/1/2010		6/30/2010	6/30/2010	710.47	2,841.87	1,420.93	-	2010 Taxes First Half
24	1401	HAYWARD - Point Eden III 461-85-31	108.83	1/1/2010		6/30/2010	6/30/2010	18.14	72.55	36.28	-	2010 Taxes First Half
25	1401	HAYWARD - Point Eden III 461-85-34-1	119.16	1/1/2010		6/30/2010	6/30/2010	19.86	79.44	39.72	-	2010 Taxes First Half
26	1401	HAYWARD - Point Eden III 461-85-48-1	20,813.18	1/1/2010		6/30/2010	6/30/2010	3,468.86	13,875.45	6,937.73	-	2010 Taxes First Half
27
28		TOTAL:	27,005.18				TOTAL:	4,500.87	18,003.45	9,001.73	0
DATA

Next, select a range of cells in column A.

Then run this macro on the sheet:

Option Explicit

Sub PrintSelections()
'Jerry Beaucaire   5/17/2010
'Based on selection in column A, printout each
'section of data as a separate print job

'Verify column A selection exists
    If Intersect(Selection, Range("A:A")) Is Nothing Then
        MsgBox "Please select a range of cells in column A"
        Exit Sub
    End If
    
'Set the print parameters
    With ActiveSheet.PageSetup
        .PrintTitleRows = "$1:$7"
        .Orientation = xlLandscape
        .FitToPagesWide = 1
        .FitToPagesTall = 1
    End With

'variables
    Dim SelectRNG   As Range
    Dim Cnt         As Long

'set the separate areas to print
    Set SelectRNG = Intersect(Selection, _
        Range("A:A")).SpecialCells(xlCellTypeConstants)

'Print each area
    For Cnt = 1 To SelectRNG.Areas.Count
        Range(SelectRNG.Areas(Cnt).Address).Resize(SelectRNG.Areas(Cnt) _
         .Rows.Count + 5, 12).PrintOut Copies:=1
    Next Cnt

'Cleanup
    Set PrintRNG = Nothing
    Set SelectRNG = Nothing
End Sub

 

[Looking for answers]

Thank you for the macro I am having one problem though.

I am getting an error message

Compile Error:
Variable not defined

The area highlighted is at the end of the macro under the section :Clean-Up"

Set Printer = Nothing

Wha is this error telling me

Thank you