I'm generating a new worksheet and setting the pagesetup to be 1 page wide. Any ideas on how I can then find the last cell that could fit on that page?
Solution: I had to change my print area to extend beyond the first page. Then, I could loop through the horizontal breaks to find the end of the first page.
Bookmarks