Create command button to print multiple worksheets in a excel file

M

MarcoR

I have never worked with a macro in excel.
I have a file with 5 worksheets.
I want to create a command button in Worksheet 1 so I can print worksheets 2
through 4 all together.
Please help.

Marco
 
J

jd1

I have tried the sheets array code, but I keep getting an error "Runtime
error 9: Sub-script out of range." Any recommendations?
 
G

Gord Dibben

That could indicate that you don't have one or more of the sheets in the array.

Check the spelling on the sheetnames and in your macro.


Gord Dibben MS Excel MVP
 
Top