Consulting

Results 1 to 3 of 3

Thread: "Can't assign to Array" Error

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    "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?

  2. #2
    VBAX Mentor tpoynton's Avatar
    Joined
    Feb 2005
    Location
    Clinton, MA
    Posts
    399
    Location
    works for me in 2004, attached

  3. #3
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    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.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •