Set Print Area Word. Debug print rngprintarea height debug print rngprintarea width debug print rngprintarea cells rngprintarea rows count rngprintarea columns count address end sub. In the page setup section click print area add to print area.
Main print area 1. Sub getprintarea dim rngprintarea as range put print area into range variable set rngprintarea sheet1 range sheet1 pagesetup printarea perform operations on range shows up in immediate window. Add cells to an existing print area on the worksheet select the cells that you want to add to the existing print area.
On the page layout tab in the page setup group click print area and then click add to print area.
On your worksheet select the adjacent cells you want to add to the existing print area. Page layout tab margins custom margins set all margins to 0. From the file menu select the print option. Open a new word document.
