pinky777
02-26-2005, 06:27 AM
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:
Dim myArray()
myArray = Range("A1:D10").Value
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.
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:
Dim myArray()
myArray = Range("A1:D10").Value
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.