Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,533
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) Keith R[_2_] Excel Programming 3 November 13th 07 04:08 PM
ReDim Array Brandt Excel Programming 3 October 9th 06 06:42 PM
ReDim string in loop Arne Hegefors Excel Programming 11 August 23rd 06 01:38 AM
Create an array inside a For...Next loop Eric Winegarner[_2_] Excel Programming 3 October 27th 05 12:26 AM
ReDim Object array as parameter of Variant array Peter T Excel Programming 4 May 10th 05 02:11 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"