Print Multiple Ranges on Seperate Sheets At Once

Hi

New to Excel VBA here.

I am trying to print my class sheet on 4 seperate A3 pages (because I have 4 ranges) with a single click of a button.

I have set the 4 ranges in my code but am still having to print the 4 ranges 4 times as opposed to with just one click of the button.

Can anyone help me here? Sheet attached.

Thanks in advance

[SOLVED]

Admin --> Sorry cannot see the 'Solved' link on the dropdown anymore.

@ technik

You've been helped here before, you got assistance from other people.
Now it's your turn to help others by posting the solution so anyone with similar situation can learn from your experience.

Thanks

NoS said:

@ technik

You've been helped here before, you got assistance from other people.
Now it's your turn to help others by posting the solution so anyone with similar situation can learn from your experience.

Thanks

Click to expand...

Hi NoS

Absolutely and that's not a problem.

Actually the code in my file seem to work on another Windows PC but not my mac. Not sure it's a bug in excel but that was the reason I closed the thread.

Thanks for all your support recently, it's appreciated.



A