Creating an array of strings

Question

I'm having a few problems with the following:

Dim design(6) As String

design(0) = "DES1"
design(1) = "DES1_slot"
design(2) = "DES2"
design(3) = "DES2_slot"
design(4) = "DES3"
design(5) = "DES3_slot"

I get the error "Expected end of statement"

Similarly:

Dim design(0 To 5) As String

design(0) = "DES1"
design(1) = "DES1_slot"
design(2) = "DES2"
design(3) = "DES2_slot"
design(4) = "DES3"
design(5) = "DES3_slot"

says "Expecting ')' "

I don't often use VBA, but from the quick googling I did at least one of these should work?

Which line is the error on? Just checking.

John Alexiou
– John Alexiou

2014-09-09 14:05:14 +00:00
Commented Sep 9, 2014 at 14:05 — John Alexiou
– John Alexiou, Commented Sep 9, 2014 at 14:05

Helen · Accepted Answer · 2014-09-10 15:25:09Z

3

Thats perfectly valid VBA however you will get those exact errors in VBScript which is what I presume your using.

As VBScript is typeless change the first line to just:

Dim design(5)

edited Sep 10, 2014 at 15:25

Helen

99.8k17 gold badges280 silver badges352 bronze badges

answered Sep 9, 2014 at 13:56

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Laurengineer Over a year ago

Ah brilliant, as I said, I don't use it much so I had no idea :)

Bond Over a year ago

Actually, you should use Dim design(5) since you define the upper-bound in VB/VBA/VBScript. Using 5 will create a six-element array (0-5)which is what you apparently need.

Collectives™ on Stack Overflow

Creating an array of strings

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related