Method 'Cells of Object' Global failed error

I am receiving the above error when attempting to execute this macro. For some reason the macro works on one computer but not the other.

When I debug it brings me to this point in the macro.

Any suggestions how to correct this would be appreciated.

Thanks

Please Login or Register  to view this content.

You can avoid the select, but I would suggest using the actual worksheet name in the code

Please Login or Register  to view this content.