PC to Mac macro speed issues

[robotman]

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

 

[Norman Jones]

Hi John.

I do not use a Mac and cannot help you with your
problem.

It may, however, be advisable additionally to address
your question to the corresponding Mc NG:

microsoft.public.mac.office.excel

 

[robotman]

The Mac forum didn't necessarily programming related so I thought this
forum might be more appropriate, but I will also post there to see
what response I get.

Thanks.

John

 

[NickHK]

Can't give you an exact answer, but maybe add some timing code (similar to
that outline in help, under "ScreenUpdating Property"), to narrow down the
problem area, if it exists.
Certain aspects of Excel work differently (or not at all) on a Mac compared
to a PC, so may depend on what you are doing.

There is the compiler direction "Mac":
#If Mac Then

#Else

#End If
so you can include/exclude certain code depending on the platform, if you
find different ways are needed/better depending on the platform.

NickHK