PRINTING : Repeat rows on bottom AND columns on right

Hello,

I didn't see a thread for this topic, so i appologize if it's already been posted - a link would be appreciated.

I have multiple worksheets/workbooks that i have this issue with so a universal code or solution would be best.

Excel has an option, that most of you are aware of to allow for rows and columns to be repeated on the top and left of each printed page. I want to be able to do the same thing with rows on the bottom and columns on the right.

Hiding rows and printing each individual page or copying what i want to print on a specific page is too time consuming and tedious.

For example i have a total print area from $A$1:$BX$35 (print area varies from sheet to sheet) i would like whats in Rows $2:$5, $30:$35 repeated on each page and Columns $A:$C and $BT:$BF repeated on each page where cells between are filled with data. I have a restriction that the viewing percentage be >70% when printed.

people on other forums have come up with solutions of creating a footer or making these right and bottom cells into images, but no code/macros, and this will not work for my application.

Has anyone developed VBA code/macro for something like this? - i don't know enough code to do this myself

please comment with solutions, hints, or questions to help clarify my problems.

Cheers!

If there are no solutions - i have started the following code as a work around - basically copy paste to a new worksheet for printing through selecting cells.

Please Login or Register  to view this content.

only problem here is when it copies and pastes to the new sheet it copies each selection vertically instead of in the same orientation that is on the original sheet. help here would be appreciated as well/instead

Thanks