[Solved] Printing: Freeze Panes & Print

  • What's the easiest way, VBA or otherwies, to print part of a worksheet when some cells are frozen.


    What I mean is, from row 5 upwards is frozen. I want to print part of the worksheet way down at around row 300, but I want rows 1-5 to be included on the printed page.


    Can anyone help?


    Thanks in advance.
    Ted

  • Use File / Page Setup / Sheet and specify the Print Area and/or Print Titles (Rows and/or columns to repeat on each page) to get what you need.


    HTH


    .....Ralph

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!