+ Reply to Thread
Results 1 to 7 of 7

Print same area on multiple sheets

  1. 07-04-2012, 02:11 AM #1
    ossa
    ossa is offline
    Registered User
    Join Date
    03-15-2012
    Location
    Stavanger, Norway
    MS-Off Ver
    Excel 2016
    Posts
    77

    Print same area on multiple sheets

    Hello!

    I have a workbook with about 100 sheets containing the same layout. I would like to set a print area on everyone of them and print out every sheet with a specific range, in this case: B2:DB83.......Does anyone have an idea, and is it possible without using macros? Thanks for any reply!

    Ossa
    Reply With QuoteRegister To Reply
  2. 07-04-2012, 02:27 AM #2
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Print same area on multiple sheets

    didn't really tried this one(actual printing)...

    perform the set print area then select the tabs using shift + mouse click...
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  3. 07-04-2012, 02:31 AM #3
    ossa
    ossa is offline
    Registered User
    Join Date
    03-15-2012
    Location
    Stavanger, Norway
    MS-Off Ver
    Excel 2016
    Posts
    77

    Re: Print same area on multiple sheets

    Did not work, if I understood you correctly...
    Reply With QuoteRegister To Reply
  4. 07-04-2012, 02:37 AM #4
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Print same area on multiple sheets

    then its vba...
    Reply With QuoteRegister To Reply
  5. 07-04-2012, 03:31 AM #5
    ossa
    ossa is offline
    Registered User
    Join Date
    03-15-2012
    Location
    Stavanger, Norway
    MS-Off Ver
    Excel 2016
    Posts
    77

    Re: Print same area on multiple sheets

    Do you have a nice code
    Reply With QuoteRegister To Reply
  6. 07-04-2012, 03:56 AM #6
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Print same area on multiple sheets

    not me...

    but here's sample


    Please Login or Register  to view this content.

    hth....
    Reply With QuoteRegister To Reply
  7. 07-04-2012, 05:03 AM #7
    ossa
    ossa is offline
    Registered User
    Join Date
    03-15-2012
    Location
    Stavanger, Norway
    MS-Off Ver
    Excel 2016
    Posts
    77

    Re: Print same area on multiple sheets

    Thanks a lot. Just what I needed
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1