technik
New member
- Joined
- Oct 8, 2018
- Messages
- 13
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- MS 2016
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
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