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

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.

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

See if

Please Login or Register  to view this content.

works instead.

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.

Originally Posted by 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.

Great! That works.

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