Macro Runs on My Computer but Not My Coworker's Computers

[EdwardSnowden]

I am having a major issue with my macro. When I run it on my computer, it runs completely fine. When I run it on my coworker's computer, who has the same version of Excel as me, the macro runs into an error on a portion of the code that is used to paste data to a new worksheet. Then, on my other coworker's computer, the macro runs into an error on a completely different portion of the code. For the second coworker, the error is on creating a pivot table. Attached is an Excel workbook with randomized data with the macro. Can any of you help on this issue? There also seems to be an issue that the pie-graphs aren't centered on certain monitors but they are on others. This is a much smaller issue but any help/advice would be highly appreciated!

Note, the button for the macro is on the "Summary" tab.

[JLGWhiz]

Without completely disecting the code (which appears to be extremely long) I can only say that for it to run on multiple computers, the system settings should all be the same, the sheet names must be identical and the sheet formatting must be identical. Your code needs to be "de-selected". It would be much more efficient if direct coding were used rather that the select methed. I realize that may be a difficult task for you, since the code was apparently developed by recoder, but for instance this

Please Login or Register  to view this content.

Can be reduced to this

Please Login or Register  to view this content.

Which is easier to read, faster and no filicker and flash.

[EdwardSnowden]

JLGWhiz: Thank you so much!

[JLGWhiz]

JLGWhiz: Thank you so much!

You are welcome,
regards, JLG