I'm writing a macro that needs to run on a PC and Mac.

I have the code working on both platforms, but the Mac is incredibly
slower. What takes 20 seconds on a PC takes over 12 minutes on the
Mac! Another thing that takes 1 second on the PC, takes over 2
minutes on the Mac. The Mac is a new MacPro.

Most of the macro is dealing with transfering information from one
spreadsheet to another and formatting cells.

* Can anyone help me understand the speed difference and if there are
any tricks to speed up the Mac? (any webpages dedicated to this
issue?)

Thanks.

John