View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aiyer[_44_] aiyer[_44_] is offline
external usenet poster
 
Posts: 1
Default Declaring variable as a dynamic array?

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

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