+ Reply to Thread
Results 1 to 1 of 1

Extra and sometimes blank pages pages being shown with print preview

  1. #1
    Registered User
    Join Date
    05-13-2024
    Location
    Reno,nv
    MS-Off Ver
    365
    Posts
    13

    Extra and sometimes blank pages pages being shown with print preview

    Hello.

    First let me give a rundown of the usage of this code / file.

    1. Import/Copy a CSV data source to a tab deleting extra entries and columns. (this has been fixed and works great)
    2. Copy that data to the Report Tab Pated below the header row that exists in row 25.
    3. Filter that pasted data based on the value in Cell b21 which gets its source from a list that is manually updated in the Route Tab Column A.
    4) After Filter it applies gridlines to the data for readability and print previews for the user.
    5) user repeats process using the next value in the b21 drop down list.

    I have tried two different methods one creating a table and one just having a range and both are subject to trailing data / blank pages or error messages when the preview is called. Code examples are below

    The method without conversion to a table - gets extra data / pages

    Please Login or Register  to view this content.
    The second method converts data to table and comes back with a "Table cannot occupy the same space" Error.

    Please Login or Register  to view this content.

    either method is fine functionally as long as there are no extra pages beyond the dataset.

    Attached is the code file "Producev3" and the data source "Orders-Result.csv"
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-24-2016, 05:28 PM
  2. [SOLVED] Print Preview ONLY showing 2 Pages, yet worksheet has more rows ?
    By mave27 in forum Excel General
    Replies: 3
    Last Post: 07-28-2015, 08:11 AM
  3. Replies: 0
    Last Post: 05-14-2013, 11:28 AM
  4. Print Preview missing pages - Pivot table
    By Mar72vin in forum Excel General
    Replies: 0
    Last Post: 01-12-2009, 01:07 AM
  5. [SOLVED] Extra Blank Pages In Preview
    By Smooth in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-24-2006, 05:40 PM
  6. [SOLVED] How to prevent extra blank pages from printing?
    By Cathy in forum Excel General
    Replies: 1
    Last Post: 10-03-2005, 12:05 PM
  7. Replies: 4
    Last Post: 04-20-2005, 01:06 PM

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