excel macro dim(17) - need explanation.

[BRUCE FOOTE]

I am running troubeshooting a macro in EXCEL 2007 .

The Dim statements appear as follows:
Dim jbnme(17) As String, cpup(17) As Integer,'.
I am familiar with the Dim variable declaration but what does the (17) represent?

thanks,

Bruce

 

[tweedle]

It's an array declared to 17.

What that really means depends on what Option Base is used.
If there is no Option Base statement or there is Option Base 0 (zero) [most common]
Then the array holds from - 0 to 17 [total of 18 positions]

If there is an Option Base 1 statement
Then the array holds from - 1 to 17 [total of 17 positions]

 

[BRUCE FOOTE]

tweedle,

I suspected that it may be an array. Thanks for the heads up about the 'Option Base statement'. This will direct me in my study & save time.

Thanks again,

Bruce