object require error

The following macro does the job of printing. But when returning from printing or when the printout was cancelled, an error message box comes out with "Object Require" on it. I need to do reset some cells format which obviosly I can not.

Please Login or Register  to view this content.

Help will be appreciated.

Thanks

Necalabria

Hi Necalabria,

Welcome to the forum!!

Try this:

Please Login or Register  to view this content.

HTH

Robert

Thanks for letting us know and you're welcome