"Can't assign to Array" Error

This works fine in Windows:

[VBA]Dim MetricArray As Variant

MetricArray = Array("X", "Y","Z")[/VBA]

But obviously it fails in OS X.

Any thoughts?

works for me in 2004, attached

Quote:

---

Originally Posted by Saladsamurai

This works fine in Windows:

[vba]Dim MetricArray As Variant

MetricArray = Array("X", "Y","Z")[/vba]
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.