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

--
Regards
Frank Kabel
Frankfurt, Germany

"aiyer " schrieb im Newsbeitrag
...
Hello all!

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

Here how do I declare the variable 'nstages' as a dynamic array, that
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.


---
Message posted from http://www.ExcelForum.com/