Results 1 to 1 of 1

"Hide Empty Rows" while printing issue

Threaded View

Tamarissa "Hide Empty Rows" while... 12-29-2015, 03:25 PM
  1. #1
    Forum Contributor
    Join Date
    06-19-2012
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    158

    "Hide Empty Rows" while printing issue

    Hi there,

    I've got a file I'm working on that I already have a module inserted to be able to print to pdf, and I am trying to add in a 'hide empty rows' code as well. The printing part works great, but I can't seem to get the empty lines to hide .
    On the printed pdf, I would just like to have 1 empty spacer line between the bottom of the pivot table and the 4 lines of extra data at the end (which will of course depend on how many lines are in each 'page' when it's filtered.

    Thanks so much for your time!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to prevent "printing" empty pages?
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2014, 11:54 AM
  2. [SOLVED] Click "-" or "+" to hide and unhide rows
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-09-2013, 08:03 AM
  3. Replies: 1
    Last Post: 09-21-2013, 03:18 AM
  4. Excel 2007 : VB code to hide rows that are empty or contain "-"
    By ironmonkey888 in forum Excel General
    Replies: 11
    Last Post: 09-23-2010, 11:18 AM
  5. Replies: 4
    Last Post: 02-03-2008, 05:11 PM
  6. Hide Empty Rows When Printing
    By Bob in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. Hide Empty Rows When Printing
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 04:05 AM
  8. [SOLVED] Can Excel "slide up" rows with content thru empty rows to condense
    By portly44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2005, 08: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