LinkBack URL
About LinkBacks
Hi friends,
Please see attached sheet.
I want Print A1 to H11 & A33 to H35, I try to select Print Areas, but coming 2 separate pages. How can I get in one page.
Thank you frineds,
Hi friends,
Please see attached sheet.
I want Print A1 to H11 & A33 to H35, I try to select Print Areas, but coming 2 separate pages. How can I get in one page.
Thank you frineds,
Hi
Add this code to a new module in VBA
Once you have added this code to the module exit VBA and then make your selection that you would like to print then go to macros and run the macro you just created.
Please Login or Register to view this content.
This may give you a close result to what you are looking for.
Thanks
Hi Jamidd1,
Actually not getting what I need.
Rajesh Sorry but multiple selected area in excel can't printable. You can do a trick for the same.Originally Posted by rajeshn_in
Camera tool. This tool allows you to capture dynamic "pictures" of different areas of your worksheet. The Camera tool is not available, by default, on any Excel toolbar. Instead, you need to add it to the toolbar. Choose Tools | Customize and make sure the Commands tab is displayed.
In the list of Categories, choose Tools, and then scroll through the Commands list until you find Camera. (Oddly enough, it has a small camera icon to the left of the command.) Drag the Camera command to a toolbar and drop it there. Close the Customize dialog box, and you are ready to use the Camera tool. Follow these steps:
Select the range that you want to take a picture of. For instance, select A1:H11, the first part of the area you want to print.
Click on the Camera tool. The mouse pointer changes to a large plus sign.
Change to a different worksheet, preferably a blank one.
Click where you want the top left-hand corner of the picture to appear. The picture is inserted as a graphic on the worksheet.
Repeat steps 1 through 4, but select the other range you want printed (A33:H35).
Check the attached file.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank u shukla
Another option is to create Summary sheet which will be printed.
*** But I noticed that your only purpose is not to print the BLANK rows. why not just hide them instead?
If you want an autohide blank rows you can create another thread in VBA subforum for the codes.
regards,
vlady
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
Yes vlady, finally i decide to hide empty rows and after that creating printarea a
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks