Results 1 to 2 of 2

Set print area

Threaded View

  1. #1
    Forum Contributor Immortal2014's Avatar
    Join Date
    09-18-2014
    Location
    Greece (EU)
    MS-Off Ver
    Office 2021
    Posts
    405

    Set print area

    Hello,

    Inside a book I have 16 ranges, each range has 52 rows, I have red borders in each range to make it easier to understand what the ranges are.

    Is it possible for the 16 ranges, in the yellow areas, which cells do not contain data, to hide the entire row?
    (In first cell of each yellow ranges i use formula filter to my book, but not here in example)


    After hiding the rows, is it possible to define as a print area as many areas that have data even in a cell in the yellow area?

    Is it possible, since the print area is defined by the areas that have data, that the areas with the red borders don't split into two pages when I'm in the print preview?
    (the areas with red borders, because each one has 40 cells available, the yellow areas, for entering data, it is certain that they will constantly increase and decrease every time the data changes)


    Thanks for your time
    Attached Files Attached Files
    Last edited by Immortal2014; 07-26-2024 at 04:46 AM. Reason: I put an example in the attachment for that i need
    Nick

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Set print area of selected range then print preview if ok then print the document!
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 07:10 AM
  2. Macro - Set Print Area for Changing Data Area
    By ksp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-27-2013, 04:19 AM
  3. Replies: 1
    Last Post: 02-12-2013, 12:16 PM
  4. VBA to set print range, open box asking for print qty, print, then redefine print area
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 06:43 PM
  5. Replies: 8
    Last Post: 05-23-2007, 06:39 AM
  6. [SOLVED] How do you turn off a print area for a page? (no print area)
    By Grunen in forum Excel General
    Replies: 4
    Last Post: 10-08-2005, 03:05 PM
  7. Print Area:What would be the code for setting the print area
    By wammer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2005, 02:05 AM

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