Hi,
I recently switched to a Mac, and when trying to use my excel-macros from winxp, I got the following problem:

the code is something like:

[VBA] Dim myArray()
myArray = Range("A110").Value[/VBA]

and runs perfectly with win, but I get an error message "cannot assign values to data array" (or something like that, it's actually in German) with mac.

I tried to get some work-around, but nothing seems to work. I know that I could assign the values through a loop, but the idea was to avoid that (because the range, actually, is much much bigger, and assigning the values to the array directly is much faster!)

Anyone a clue?
Paul.