Declare variables within a loop?

**marsul** · 04-15-2020, 03:43 AM

I´d like to dim as many variables, varX, as the cell A1 says. Let´s say the value in A1 = 3.

Something like this:

Please Login or Register  to view this content.

The use for these varX variables is to keep track of a couple of For loops.
From the beginning of the code, I don´t know how many loops I need.
The final result I´m looking for is:

Please Login or Register  to view this content.

**Kaper** · 04-15-2020, 04:00 AM

There is more than just control variable which is to be dynamic - you will need a dynamic number of for-next loops.

I doubt if you can do it. so may be rethink your algorithm.

It seems that a recurrence algorithm with the current number of control variable passed as one of the parameters shall be an answer .

**Kaper** · 04-15-2020, 04:20 AM

An example of such approach from other forum - unfortunately in Polish: http://www.excelforum.pl/viewtopic.php?p=205542 (there are similar threads here, but unfortunately "Search" at our forum is currently not working too well):

Please Login or Register  to view this content.

**marsul** · 04-15-2020, 04:36 AM

Thank you Kaper for your answers.

I guess you´re right, I´ll check in to that.

Declare variables within a loop?

LinkBack

Thread Tools

Rate This Thread

Display

Declare variables within a loop?

Re: Declare variables within a loop?

Re: Declare variables within a loop?

Re: Declare variables within a loop?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Declare 2 variables instead range

[SOLVED] How do you declare several variables?

How do you declare several variables?

[SOLVED] How to declare variables

Why declare variables

[SOLVED] How to efficiently declare variables

[SOLVED] declare Variables

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions