VBA for Multiply Print Areas

[karolina1406]

Can someone help me create a Command Button for creating a Print of 3 print areas which would then be printed on a separate page but fit the whole page? My printing areas are: E5:AF30, D37:AF70, D71:X98 and D100:Z131

thank you in advance

 

[XLfriend777]

Hi karolina1406. Have you thought about just selecting

D5:AF131 as your Print Area? You could then set the print to be 3 pages. Hope this helps get things started.

<colgroup><col style="width:65pt" width="65"> </colgroup><tbody>
</tbody>

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }</style>