I found the following code that prints selected rows on a single sheet. It doesn't work quite like I need it to.
There are two main issues:
1. The blank rows between the selected rows are not removed (i.e. if I select row 3 and row 7, there are 3 blanks lines between the printed rows).
2. It only prints in portrait mode. I need it to print in landscape.
I am not a VBA programmer and know nothing about it. I am asking if someone can add to or fix the code so it works like I need it to.
Please Login or Register to view this content.
Bookmarks