+ Reply to Thread
Results 1 to 3 of 3

Print only visible sections

  1. #1
    Registered User
    Join Date
    03-16-2004
    Posts
    23

    Print only visible sections

    Hello,
    I have a set print range in 1 worksheet, inside of which sections of rows can be hidden or unhidden (and the hidden ranges can change in size). I'd like to be able to print only the visible sections within the print range. Is there a property/command that will do this?
    Thank you!!

  2. #2
    Registered User
    Join Date
    12-18-2006
    Posts
    36
    I am not sure if this is what you mean.

    Selection.PrintOut Copies:=1, Collate:=True

    That will print out the selected area, hidden rows don't print.

  3. #3
    Registered User
    Join Date
    03-16-2004
    Posts
    23
    Yes I think that will work...sometimes the page numbers aren't "updating" properly...for example, if I hide a section in the middle of 2 pages, the last page will update itself to page #3 instead of page #2, but I will work with the print ranges on this. Thanks for your help!

+ 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