All,
I have a working macro that splits out invoice lines to separate tabs and I have formatting set. I am attempting to add code for the print area. I found a working suggestion online but don't know how to incorporate within this macro so that all tabs have this page setup. Can someone assist? Thanks in advance
Code to Add
Please Login or Register to view this content.
Current Macro
Please Login or Register to view this content.
Normally you can loop through the sheets like this,
Run the code by itself to see it work.Please Login or Register to view this content.
I'm still having issues including this in my original macro. The code below only works on the active sheet. How can I change it to include all sheets?
Please Login or Register to view this content.
Try this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
xladept - thank you! that worked great and i was able to easily add to my original macro.
You're welcome and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks