![]() ![]() Similarly, the named ranges-which are really single cells-used for the left portion of the headers are NorthHead, SouthHead, EastHead, and WestHead. These areas are named ranges: North, South, East, and West. This example prints out only four areas of a worksheet. 'Fill this array with the names of the ranges to be in the headerĪ = Range(Region(x)).AddressĪ = Range(Head(x))Ī Copies:=1 'Fill this array with the names of the ranges to be printed 'Change the dimension of the arrays to equal the number ![]() The following macro will implement the above steps: You could have a named range for each portion of the worksheet that you want to print, and a named range (which would be a single cell) that represents the header or footer information that you want for each print area. Notice that these steps require the use of named ranges.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |