Results 1 to 4 of 4

Thread: Print Multiple Ranges on Seperate Sheets At Once

  1. #1
    Seeker technik's Avatar
    Join Date
    Oct 2018
    Posts
    8
    Articles
    0
    Excel Version
    MS 2016

    Print Multiple Ranges on Seperate Sheets At Once



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    New to Excel VBA here.

    I am trying to print my class sheet on 4 seperate A3 pages (because I have 4 ranges) with a single click of a button.

    I have set the 4 ranges in my code but am still having to print the 4 ranges 4 times as opposed to with just one click of the button.

    Can anyone help me here? Sheet attached.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Seeker technik's Avatar
    Join Date
    Oct 2018
    Posts
    8
    Articles
    0
    Excel Version
    MS 2016
    [SOLVED]

    Admin --> Sorry cannot see the 'Solved' link on the dropdown anymore.

  3. #3
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    722
    Articles
    0
    Excel Version
    Excel 2010 64bit
    @ technik

    You've been helped here before, you got assistance from other people.
    Now it's your turn to help others by posting the solution so anyone with similar situation can learn from your experience.

    Thanks

  4. #4
    Seeker technik's Avatar
    Join Date
    Oct 2018
    Posts
    8
    Articles
    0
    Excel Version
    MS 2016
    Quote Originally Posted by NoS View Post
    @ technik

    You've been helped here before, you got assistance from other people.
    Now it's your turn to help others by posting the solution so anyone with similar situation can learn from your experience.

    Thanks

    Hi NoS

    Absolutely and that's not a problem.

    Actually the code in my file seem to work on another Windows PC but not my mac. Not sure it's a bug in excel but that was the reason I closed the thread.

    Thanks for all your support recently, it's appreciated.



    A

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •