| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array in VBA
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
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
Try sticking Dynamic Array Excel VBA into google......
"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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
Ok, THANKS !!!
Best regards, Piotr :-) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
Ok, THANKS !!!
Best regards, Piotr :-) |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
Also check the responses in .developer.vba
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
Dynamic array, yes; static array, no. What do you want to change? From
what to what? Alan Beban Piotr wrote: 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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
In one dimension there is no problem.
If I have twoj dimensions or more... I lose my data - but If I use ReDim Preserve I won't lost data only in the last dimension ? Is there any other possibilities ? Best regards, Piotr :-) "Alan Beban" wrote in message ... Dynamic array, yes; static array, no. What do you want to change? From what to what? Alan Beban Piotr wrote: 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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
Let me try again. What do you want to change from what to what? Perhaps
you could give a simple illustration of what you are trying to achieve in a two-dimensional array. Alan Beban Piotr wrote: In one dimension there is no problem. If I have twoj dimensions or more... I lose my data - but If I use ReDim Preserve I won't lost data only in the last dimension ? Is there any other possibilities ? Best regards, Piotr :-) "Alan Beban" wrote in message ... Dynamic array, yes; static array, no. What do you want to change? From what to what? Alan Beban Piotr wrote: 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 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
Hi Alan
I havn't any real problem - I learn VBA and I'd like to know all possibiliteis about changing size of arrays. Sorry if my questions are stupid :-( Best regards, Piotr "Alan Beban" wrote in message ... Let me try again. What do you want to change from what to what? Perhaps you could give a simple illustration of what you are trying to achieve in a two-dimensional array. Alan Beban Piotr wrote: In one dimension there is no problem. If I have twoj dimensions or more... I lose my data - but If I use ReDim Preserve I won't lost data only in the last dimension ? Is there any other possibilities ? Best regards, Piotr :-) "Alan Beban" wrote in message ... Dynamic array, yes; static array, no. What do you want to change? From what to what? Alan Beban Piotr wrote: 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 |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
No, no! Not stupid at all. I'm just trying to get a fix on exactly what
you are trying to accomplish. You might want to review the Sub Procedure ResizeArray in the freely downloadable file at http://home.pacbell.net/beban Alan Beban Piotr wrote: Hi Alan I havn't any real problem - I learn VBA and I'd like to know all possibiliteis about changing size of arrays. Sorry if my questions are stupid :-( Best regards, Piotr |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array in VBA
Thank you Alan :-)))
It's very helpful :-)))) Best regards, Piotr :-) "Alan Beban" wrote in message ... No, no! Not stupid at all. I'm just trying to get a fix on exactly what you are trying to accomplish. You might want to review the Sub Procedure ResizeArray in the freely downloadable file at http://home.pacbell.net/beban Alan Beban Piotr wrote: Hi Alan I havn't any real problem - I learn VBA and I'd like to know all possibiliteis about changing size of arrays. Sorry if my questions are stupid :-( 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 | |||
![Piotr[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
