Printing multiple Sheets based on a cell value within the sheet

[coral767]

I have a large workbook 100+ sheets and I'm looking to create a print button that only prints the sheets that have a certain value in cell "N1" in the worksheet, in this case "A".

I'm stuck and your advice would be much appreciated. (I'm still a newbie with VBA so go easy on me please if I'm way off)

This is what I have so far but not working:

Please Login or Register  to view this content.

[JLGWhiz]

See if this will do it.

Please Login or Register  to view this content.

[coral767]

Thanks for trying but.. Still getting a Run-Time Error. "Object doesn't support this property or method"

[mjr veverka]

You forgot about the "Worksheets" collection:

Please Login or Register  to view this content.

[coral767]

Yes. That did it, Thank you! They are printing, however, I still get a Run-Time error '13' after it runs. Ideas?

[mjr veverka]

Look here:

https://msdn.microsoft.com/en-us/vba...match-error-13

and/or give us information about the line of code that generates the error.

[JLGWhiz]

this should run OK

Please Login or Register  to view this content.

the error was being caused by the comma that followed 'PrintOut'. VBA was expecting a different parameter for that position.