Hello All
I would like code that will print multiple worksheets ( sheets A,B,C,D ) using the cell value in cell A1 from a worksheet called "dashboard" in the same workbook
thank you in advance
Hello All
I would like code that will print multiple worksheets ( sheets A,B,C,D ) using the cell value in cell A1 from a worksheet called "dashboard" in the same workbook
thank you in advance
Hi muss1210,
Try this:
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Hello Robert
Thanks for replying
The warning message works fine but I get a error on the below line, the error message is Runtime error '9' , subscript out of range
thanksPlease Login or Register to view this content.
That means there's a sheet that the code is trying to refer to that doesn't exist in the workbook. The code needs five tabs exactly named as follows to work:but I get a error on the below line, the error message is Runtime error '9' , subscript out of range
dashboard
A
B
C
D
At a guess I'd say it's one or more of the four array items (i.e. A, B, C, D) that don't have a corresponding tab in the workbook. Make sure to have the relevant tab names you want to print exactly as they appear in the workbook in the array and try again.
Robert
Ahhh all sorted, on my worksheet I had miss spelled a tabs name. now works great.
Many thanks
That's great. Thanks for the rep
Hello Trebor
As always I have now been asked if the sheets can be printed in order multiple times , eg ABCD ABCD ABCD rather than AAA BBB CCC DDD
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks