Setting array length as variable value?

Question

I was wondering if it's possible to set an array's length as a variable value as it would help a lot with my current function.

Essentially what I want to be able to do is:

q = 2
Dim AnswerIDs(q)

However, this results in an error, does anyone know how I could do this?

stovroz · Accepted Answer · 2014-02-22 15:21:52Z

4

q = 2
Dim AnswerIDs()
Redim AnswerIDs(q)

answered Feb 22, 2014 at 15:21

stovroz

7,1052 gold badges52 silver badges61 bronze badges

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

Comments

Wasim · Accepted Answer · 2014-02-23 05:06:16Z

0

You can do as follows:

q = 2
Dim AnswerIDs(), i
ReDim AnswerIDs(-1)
i = 0
Do While q > i
  ReDim Preserve AnswerIDs(UBound(AnswerIDs) + 1)
  AnswerIDs(UBound(AnswerIDs)) = "test"
  i = i + 1
Loop

edited Feb 23, 2014 at 5:06

answered Feb 22, 2014 at 15:12

Wasim

1,17211 silver badges25 bronze badges

1 Comment

user692942 Over a year ago

What syntax is that, it certainly isn't vbscript can you even use ReDim AnswerID(-1) like that and what is with i++ this isn't c# or javascript.

Collectives™ on Stack Overflow

Setting array length as variable value?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related