Within VBA, I know how to print non-contiguous ranges. I simply set up the range as (a1:a30,c5:c35,q1:a30).select. This works fine, BUT, each range is printed on a separate page even though there is plenty of room to print the 3 selections on 1 page. I have searched and searched and still have not found an answer. Does anyone know? Thank You Kindly.
Good afternoon JARLATH1000
...and welcome to the forum!!
Ole P Erlandsen provides a solution here :Originally Posted by JARLATH1000
http://www.erlandsendata.no/english/...intmultiselect
Or John Walkenbach's Pup6 will do this for you if you want a ready made solution (Pup v6 > Printing > Print Multiple Selection Wizard). You can download a fully working evaluation copy from here, but if you like it and continue using it you should register it :
http://j-walk.com/ss/pup/pup6/trial.htm
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks