VBA PC-Mac Compatibility

G

Guest

I'm writing VBA code to be used on both PC & Mac, using Excel 2003 SP1.
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.

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.
 
D

Dave Peterson

From the posts I've read by Mac Users, I would have thought that you were doing
things perfectly.

But if you don't get a response in this newsgroup, you may want to try:
microsoft.public.mac.office.excel
 

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

Copy value from changing cells without VBA 1
VBA code for pasting links -- modifying RDB code for summary workbook 10
Formatting and copy or copy and formatting ?? 2
Copy Dynamic Range problem 2
Pasting into an active cell 3
why can a pc open file but not mac 2
A simple if <> nn then Msgbox "No Match" 5
Macro slow when copy and pasting 1

Top