| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array in VBA
Dim ary, i
ReDim ary(1 To 5) For i = 1 To 5 ary(i) = i Next i MsgBox ary(5) ReDim Preserve ary(1 To 6) ary(6) = 6 MsgBox ary(5) MsgBox ary(6) -- HTH Bob Phillips "Piotr" wrote in message ... Hi How can I change the size of array in VBA ? Is it possible to change static array or dynamic array ? Please, help me. THANKS ! Best regards, Piotr |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
Ok, THANKS !!!
Best regards, Piotr :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Assigning 10x1 array to 2nd collumn of 10x3 array | Excel Programming | |||
| variant array containing cel adresses convert to actual ranges-array | Excel Programming | |||
![Bob Phillips[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
