Mac VB Copy problem in Office 2004

[scholzilla]

Hi,

For some reason, the copy function doesn't work in my Excel 2004
visual basic editor. Both scripts that I had written and used with
Excel X and those new ones that I've written for Excel 2004 are
incapable of copying and I always get this typically ambiguous and
frustrating response:

"Run-time error 1004: Method Copy of Range failed'

This problem never existed before I switch to 2004 and I've
reinstalled to ensure that this wasn't the problem. Other functions,
such as Delete, appear to work normally. Does anyone know what's
wrong?

Thanks

 

[JE McGimpsey]

Hi,

For some reason, the copy function doesn't work in my Excel 2004
visual basic editor.

It's a bug:

http://www.mcgimpsey.com/macoffice/excel/04/xl04bugs.html#Range_Copy