Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q: Declaring a dynamic array
Can anyone explain how to declare an array of form:
Arr(X1, X2, ..., Xn) Where n is user defined variable? How would I read/write data from such an array? Thanx in advance! srdjan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaring a dynamic array
Srdjan,
Try something like the following: Dim Arr() As Long Dim N As Long N = 10 Redim Arr(1 To N) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Srdjan Kovacevic" wrote in message ... Can anyone explain how to declare an array of form: Arr(X1, X2, ..., Xn) Where n is user defined variable? How would I read/write data from such an array? Thanx in advance! srdjan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Sum Array Formula Input Help | Excel Discussion (Misc queries) | |||
array formula with a dynamic range. | Excel Worksheet Functions | |||
How to declare a dynamic array | Excel Discussion (Misc queries) | |||
declaring an array of CheckBox's | Excel Programming | |||
Declaring Dynamic Multi-dimensional Array | Excel Programming |