VBA to automate printing of different selection on same sheet

    Re: VBA to automate printing of different selection on same sheet


    Since I cannot test the macro ...


    To be on the safe side ...You should perform tests to achieve what you need ... and then turn on your macro recorder ...


    Cheers

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Re: VBA to automate printing of different selection on same sheet


    I've researched a bit into this and I've learnt that Excel always prints different print areas on different pages. The only way to get them to print on same page is to hide the rows that don't need to be printed. I've done it and it works.

    Re: VBA to automate printing of different selection on same sheet


    Glad you could fix your problem ...:wink:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

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

Register Yourself Login