"constant expression required" error given when setting up an array

[luv2glyd]

Trying to set up an array, but get "constant expression required" error with bars_qty highlighted on the last line. Any idea what's causing this?

Please Login or Register  to view this content.

[MarvinP]

Looks like you can't use a variable in a Dim statement.

See if

Please Login or Register  to view this content.

works instead.

[xlnitwit]

Hi,

You can only resize a dynamic array using a variable. So either use a constant thus

Please Login or Register  to view this content.

or a dynamic array

Please Login or Register  to view this content.

The initial Dim statement is optional here.

[luv2glyd]

Hi,

You can only resize a dynamic array using a variable. So either use a constant thus

Please Login or Register  to view this content.

or a dynamic array

Please Login or Register  to view this content.

The initial Dim statement is optional here.

Great! That works.

[xlnitwit]

You're welcome and thank you both for the rep.