LinkBack URL
About LinkBacks
I've been using the following VBA to print worksheets where the print area remains constant.
What I need now is a macro that will print the selection instead of a static print area.
Please Login or Register to view this content.
Any ideas?
I've been using the following VBA to print worksheets where the print area remains constant.
What I need now is a macro that will print the selection instead of a static print area.Please Login or Register to view this content.
Any ideas?
This works in Excel 2007.
Please Login or Register to view this content.
Last edited by Epscan; 11-27-2012 at 05:16 PM.
Once you set up the print areas in worksheet then the below should work:
You dont need to define ranges in the code again.Please Login or Register to view this content.
If solved kindly remember to mark Thread as solved.
Click the small star icon at the bottom left of my post if this was useful.
Once you set up the print areas in worksheet then the below should work:
You dont need to define ranges in the code again.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks