+ Reply to Thread
Results 1 to 2 of 2

Set a Print Area Range

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    259

    Set a Print Area Range

    Hi, I have a workbook example but no code yet, just after some ideas. Worksheet 1 contains about 600 rows and worksheet 2 contains about 50. What I would like to do is set a print area range to say (70 Rows) then if the print area is greater than 70 Rows it would place the next part of the area on to the next new page, make sense?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    259

    Re: Set a Print Area Range

    Update, looking at the print preview I guess I need to set the print area range to (53 Rows), any ideas?

+ Reply to Thread

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