Results 1 to 1 of 1

Find Last Printed Cell on Fitted Page

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Find Last Printed Cell on Fitted Page

    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.
    Last edited by yawnzzzz; 02-28-2012 at 05:55 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1