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
