Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dYNAMIC Array declaration, a small correction in my last thread!
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Declaration. | Excel Discussion (Misc queries) | |||
How do I create a small array from a larger one? | Excel Discussion (Misc queries) | |||
Small Array is too big for AVERAGE Function? | Excel Worksheet Functions | |||
Dynamic Array | Excel Programming | |||
see if dynamic array used | Excel Programming |