Declaring variable as a dynamic array?

[aiyer]

Hello all!

A quick qn. guys. Pl. refer the following macro.

Here how do I declare the variable 'nstages' as a dynamic array, tha
can store as many values as stored in the variable 'stages'?

==============================================
Sub triall()

x = 0

stages = InputBox("Enter the number of stages for CDF comparison")

x = x + stages

Do Until x

nstages = InputBox("Enter the stage number!")

Loop


End Sub
==============================================
Wouldappreciate your help.


Thanks a bunch.

Regds,

Arun.

Vtec corp

 

[Frank Kabel]

Hi
have a look at the Redim statement in the VBA help