PDA

View Full Version : "Can't assign to Array" Error



Saladsamurai
12-02-2009, 03:41 PM
This works fine in Windows:

Dim MetricArray As Variant

MetricArray = Array("X", "Y","Z")

But obviously it fails in OS X.

Any thoughts?

tpoynton
12-02-2009, 06:51 PM
works for me in 2004, attached

shades
12-09-2009, 02:21 PM
This works fine in Windows:

Dim MetricArray As Variant

MetricArray = Array("X", "Y","Z")
But obviously it fails in OS X.

Any thoughts?
Are you using XL 2008? It does not include any VBA. As tpoynton noted, you need XL 2004.