Excel Macro: Why range.copy doesn't work?

[Gary Schneider]

Hello world,

I've done a lot of VBA programming for Excel in WinXP, but I'm new in
the Mac world. I'm testing one of my macros and I wonder why the
statement

Range("A1").Copy

raises an exception. The message says that the copy method of the range
is wrong.
But I wonder what can be wrong in this simple statement.
I'm using Copy without the destination parameter, because I want to do
a PasteSpecial afterwards.

I've tried also

Rows(22).Copy
Rows("22:22").Copy
Range("A22").EntireRow.Copy

but all of them stop with the same error. I've tried it on different
files, no success.
Could there be any weird option ssetting preventing to copy? Or am I
making just a stupid beginner's mistake?

I'm desparate, please help!

TIA
Gary

 

[Bernard Rey]

Well, it *should* work as expected. And each of the three lines in your
script do copy Row 22.

Are you sure your copy of Office is correctly updates (should be 11.3)? Is
the ActiveSheet the one you expect?


--
Bernard Rey - Toulouse / France
MVP - office:macintosh http://faq.office.macintosh.free.fr



Gary Schneider :