I need a macro that will find “effective” in a column, select that cell and cells below until “effective” reappears. Once all cell “groups” have been selected I need to print the selected cells with rows 1:7 to repeat at top.
I need a macro that will find “effective” in a column, select that cell and cells below until “effective” reappears. Once all cell “groups” have been selected I need to print the selected cells with rows 1:7 to repeat at top.
Hi macronovice1
Welcome to the Forum!!
This code will set your Page Breaks at each instance of "effective".Place the code in a General Module. I wasen't able to make sense of this from your Sample FilePlease Login or Register to view this content.
So, I have no code for that.I need to print the selected cells with rows 1:7 to repeat at top.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks