![]() Is there an easier way to select just one of the pages of the print area? Then I would have to write more code for selecting a second and third page if they exist, going from one page break to the next or the end of the print area. Set rng = wksht.Range(rng.Address, wksht.Cells(prntArea.Cells(1, 1).Row, prntArea.Cells(prntArea.Count).Column).Address) Set rng = wksht.Range(rng.Address, wksht.HPageBreaks(1).Location.Offset(-1).Address) I have written code to select page 1: Dim wksht As Worksheet ![]() How would one go about selecting just the cells in only or the cells in page 2 only of the print area. Each print area has 0 or more page breaks defined. I have a workbook with several worksheets with Print Areas defined.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |