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,


    Edited once, last by royUK ().

  • 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.


Participate now!

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