Help Fixing Error on Print Macro

[groundin]

I found this on Ron DeBruins site. Works great, until I tried to modify it...
Basically I want it to print any hidden sheets that have a value in cell A600. I changed one line in the code and now get the error in the attached file on the line indicated in the code. Also added the original code so you can see the change I made

Please Login or Register  to view this content.

error.PNG

[Leith Ross]

Hello groundin,

You need to change the With..End With portion of your code. You can use an Array with the Sheets object to select sheets in workbook but not the Worksheets object. here is the corrected code.

Please Login or Register  to view this content.

[groundin]

Thanks, Changed it, but still getting same error...I was looking at the code, should i change

Please Login or Register  to view this content.

worksheets here to sheets as well?

[groundin]

Hi Again,
I tried changing the .Worksheets to .Sheets, but still got the same error. Here is the existing code.

Please Login or Register  to view this content.

Any help would be appreciated.
Thanks

[groundin]

Hi All,
Here is the code that ended up doing what I needed it to do. Thanks for your time.

Please Login or Register  to view this content.