Can I define an array constant?

[JenniferMurphy]

Is there a way I can define an array constant?

I tried to use the Array function

Const cols As Variant = Array(1, 4, 7, 10, 13)

but it gets an error that it expected a constant expression. Seems like that is a constant expression to me, but what do I know?

I know I can define a constant list and then use Split to turn into an array, but that is not a constant.

Any other ways?

 

[JenniferMurphy]

That structure is not a VBA construct...

I'm sure you are right. But those are details "under the hood". IMHO, VBA should provide array constants. Whatever they need to do to make that happen, they should do. That's why they pay those M$FT developers. No?

Anyway, I'm going to go with a string constant that I split into an array. The constants of the array can be changed (not read only like a constant), but close enough for what I need. However, I am having trouble with that, too. So if you have time, tell me what I am doing wrong with Split? (sigh)

 

[Rick Rothstein]

You haven't told us how you attempted to use Split when it didn't work for you.

 

[JenniferMurphy]

You haven't told us how you attempted to use Split when it didn't work for you.

I started a new thread. I thought putting it here would violate the rules against multiple topics in a single thread.

 

[Rick Rothstein]

Ah, good point.