VBA PC-Mac Compatibility

M

MikeM

I'm writing VBA code to be used on both PC & Mac, using Excel 2003 SP1 for
the PC version.

Everything works but turning off screenupdating on the Mac. I copy ranges
from 3 sheets in 1 workbook and paste them into another workbook, and I don't
want the users to see this. Why doesn't Application.ScreenUpdating work?

Alternatively, I tried to copy without choosing the workbook, with a command:

workbook(A),sheets(B).range(C).copy

instead of

workbook(A).select
sheets(B)range(C).copy

but I can't do that (why?), so the Mac user keeps seeing the back-and-forth
copying.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA PC-Mac Compatibility 1
Open four Wbooks, copy four columns from each to Master Wbook 16
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
VBA for Dependents shortcut menu 0
Similar Book to Book Code, one works other does not 11
VBA code for pasting links -- modifying RDB code for summary workbook 11
Cell values to an array, then array transpose to another workbook 8
VBA to copy from one workbook into another 0

Top