Declaration Issues with Array - Expected End of Statement

You can't declare arrays like that in VBA.

There are various options for declaring/populating arrays, this is perhaps the simplest.

Dim numbers As Variant

    numbers = Array(1,2,4,8)