Compile error: Constant expression required

[luolovepi]

I have two predefined integer variables "tableContentRows" and "NoOfRowsInsert". And they both have been assigned a value. But strangely, I got a compile error when I tried to run the code. How come?

Dim tempClick(1 To (tableContentRows + NoOfRowInsert)) As Integer

Yours Sincerely,
lolo^^

 

[Hermanito]

Can you explain what you think that line of code should do, because syntactically it makes no sense to me... you seem to be combining a variable declaration with some kind of for-next loop??

 

[Ruddles]

DIM statements aren't executed when the program runs - they're directives telling the compiler to allocate space to the variable or, in this case, the array, when your code is compiled.

Since those variables don't have a value at compile time, the compiler cannot use them to allocate the space your array requires.

You would have to declare the array as Dim tempClick() As Integer which tells the compiler you're going to provide the size of the array during execution, and then size it like this:-

ReDim tempClick(1 To (tableContentRows + NoOfRowInsert))

 

[Richard Schollar]

Hi

Use Redim instead:

Redim tempClick(1 To (tableContentRows + NoOfRowInsert)) As Integer</PRE>

 

[Richard Schollar]

You would have to declare the array as Dim tempClick() As Integer

You can just do it in one line with Redim - you don't have to use Dim as well.

 

[luolovepi]

Got it! Thank you Ruddles!

DIM statements aren't executed when the program runs - they're directives telling the compiler to allocate space to the variable or, in this case, the array, when your code is compiled.

Since those variables don't have a value at compile time, the compiler cannot use them to allocate the space your array requires.

You would have to declare the array as Dim tempClick() As Integer which tells the compiler you're going to provide the size of the array during execution, and then size it like this:-

ReDim tempClick(1 To (tableContentRows + NoOfRowInsert))

 

[Hermanito]

aha, it was meant as an array, I totally missed that

 

[luolovepi]

Thank you Richard!

You can just do it in one line with Redim - you don't have to use Dim as well.

 

[luolovepi]

^-^. Thank you too~~

aha, it was meant as an array, I totally missed that

 

[Ruddles]

You can just do it in one line with Redim - you don't have to use Dim as well.

Good grief... you're right! I honestly didn't know that!