VBA coding to print more than 1 sheets of worksheets in 1 go using only 1 button.

[lbceug79]

Hi all,

Please refer to the following codings.

Please Login or Register  to view this content.

the above codings only manage to print 1 sheet for my worksheet.
I have a total of 3 sheets on my worksheet.
I currently used 3 buttons to print all 3 sheets.
How do I alter the codes to print all my 3 sheets in 1 go using only 1 button?
Do advise on this.

Much Thanks,
Regards,
Eugene

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[lbceug79]

Hi mdm,

Sorry for this little error made...
I had actually manage to resolved this issue myself. i will proceed to close this post.

Actually for those who also looking to solve this issue.
All i did was added an ARRAY("sheet 1", "sheet 2") in sheets() and it works.

For future posts i will surely add the tag. As i was away from the forum for quite sometime, so i had forgotten this part of post, my bad.

Thanks for the advise mod, will take note on future posts.

Regards,
Eugene