Printing using Autofilter

  • Hi,


    I would like to print a header (rows 1-9) with each row from the Autofilter list on a separate page. I have written the code below but this is only printing the header (rows 1-9).


    Can anyone help?


    Many thanks,

    Karla



  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post


    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.


    How to use code tags


    Just highlight all of the code and press the <> in the post menu above button to add the code tags.


    Thanks.

Participate now!

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