ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can an array be redim inside a for loop? (https://www.excelbanter.com/excel-programming/409664-can-array-redim-inside-loop.html)

kcenac

Can an array be redim inside a for loop?
 
Am trying to write a vba program which needs to redim an array and
populate it with new numbers. But when i get to the part of the code
with for loop statement with the redim array inside the debugger just
jumps over that part of the code and go to another section.

Rick Rothstein \(MVP - VB\)[_1764_]

Can an array be redim inside a for loop?
 
Yes, you can ReDim a dynamic array inside a loop (you can ReDim it at any
time actually). Show us your code and we'll see if we can spot any problems
in it.

Rick

"kcenac" wrote in message
...
Am trying to write a vba program which needs to redim an array and
populate it with new numbers. But when i get to the part of the code
with for loop statement with the redim array inside the debugger just
jumps over that part of the code and go to another section.



Per Jessen

Can an array be redim inside a for loop?
 
Hi

Like always, show us your code for further comments.

Regards,
Per

"kcenac" skrev i meddelelsen
...
Am trying to write a vba program which needs to redim an array and
populate it with new numbers. But when i get to the part of the code
with for loop statement with the redim array inside the debugger just
jumps over that part of the code and go to another section.




All times are GMT +1. The time now is 09:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com