Hello all!

A small correction in my last thread.

In the following macro, how do I declare the variable 'Y' as a dynami
array, that can store as many values as stored in the variabl
'stages'?

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

x = 0
i=1

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

x = x + stages

Do Until x

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

Y(i) = nstages

i = i + 1

Loop


End Sub
==============================================


Another quick qn:

I deleted the default 'Help' menu from Excel while defining my ow
Menus. How do I get it back to the Excel? I did'nt save the changes
still it did'nt even prompt me while I closed the Excel workbook and
lost the default 'Help' menu from the toolbars.

Would appreciate your help.


Thanks a bunch.

Regds,

Arun.

Vtec corp

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