+ Reply to Thread
Results 1 to 8 of 8

Print multiple range from one sheet with conditon

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Print multiple range from one sheet with conditon

    hello

    i have data in range C10:G1000, J10:K1000, L10:M1000, N10:O1000, R10:S1000, T10:U1000, V10:W1000, X10:Y1000

    I want i select manual ranges from my sheet, then print the selected range


    thanx

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Print multiple range from one sheet with conditon

    Hi, haroon2015,

    and how would you like to select the manual ranges? Each individual by mouse, by cursor, from Data/Validation, with help of a UserForm? Should we consider which solution might be best for you?

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Print multiple range from one sheet with conditon

    Hi, sorry to reply.

    i have bad english to understand your post.

    try
    Please Login or Register  to view this content.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  4. #4
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Print multiple range from one sheet with conditon

    hello HaHoBe

    i would like to select manual ranges Each individual by mouse

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Print multiple range from one sheet with conditon

    Hi, haroon2015,

    Iīd definitely preferred to have the areas listed as a Data/Validation list and rely on that but maybe try
    Please Login or Register  to view this content.
    Ciao,
    Holger

  6. #6
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Print multiple range from one sheet with conditon

    hi, HaHoBe

    i m selecting ranges a2:a8, c2:c8, f2:f10, now i m printing, these ranges is printing with 3 different sheets(paper), if select 4 range its printing on 4 sheets(paper),,
    i want if select ranges :

    a2:a8, c2:c8, f2:f10, it combine with one page, and result should be on one page

    thanx

  7. #7
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Print multiple range from one sheet with conditon

    Hi,m haroon2015,

    do exactly as you have posted: copy the ranges to a new sheet and print if you want only these ranges. You didnīt spcify if these ranges should be put in the same places or directly next to each other.

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Last edited by HaHoBe; 04-30-2014 at 12:28 PM.

  8. #8
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Print multiple range from one sheet with conditon

    Amzaing
    superb

    thanx a lot HaHoBe works as i wanted

    will add reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Save multiple sheet/print sheet with one command button
    By GJR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2014, 03:06 PM
  2. [SOLVED] Stop Print If conditon are not met
    By robrobet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-30-2013, 01:35 PM
  3. 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
  4. Replies: 2
    Last Post: 10-03-2008, 09:08 PM
  5. Print a range on multiple worksheets on one sheet of paper?
    By RoyalStreet in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2006, 12:30 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