how to make a for next loop dynamic

[dmcgov]

i have the following:

Please Login or Register  to view this content.

how can i dynamically change the start and end variables to new values?

[Marc L]

Unclear … Maybe just using an InputBox, some cells, some … ?

[Eastw00d]

Hi, I get an error when I try to use the reserved word "End" as you do, so I changed this variable into "halt" (It is never a good idea to use reserved words as variables)
I have this solution for you:

Please Login or Register  to view this content.

Cheers
Erwin

[Eastw00d]

If you want to continue counting you could add this line after the IF statement:

Please Login or Register  to view this content.

Cheers
Erwin

[Marc L]

As nothing is 'dynamic' under Excel, just following the procedure in step-by-step debug mode …

[Marc L]

In fact the 'dynamic' way is to not use any For … Next loop as obviously not 'dynamic'

but just some 'dynamic' loop block like While … Wend or Do … Loop with the variables accordingly …

[dmcgov]

thanks eastwood, that did the trick.

[Eastw00d]

You are welcome.
If my assistance has helped, and only if you wish to, there is a reputation icon * on the left hand side - you can add to my reputation here.

Cheers
Erwin