Add to the loop length in a For/Next

[bentod]

I have a for next loop that uses the number of parent parts (last row in a column) to determine how many times to loop.

When I paste stuff into the parent column I am adding the number of items I added to the number of parent parts. However, it still only runs until the original number has been met.

How should I be doing this?

Please Login or Register  to view this content.

Download the attachment for details. It should insert child parts based on their parent part number.

[Norie]

You can't change the 'length' of a For Next loop within the loop.

What is it you are trying to do with your code?

Perhaps you need another type of loop, or even a loop within a loop.

[bentod]

The original column length dictates the amount of loops. When rows get inserted into the table, the column length grows. Therefore, my code ends prematurely.

[bentod]

Looks like a Do While is the ticket.

[Norie]

Try looping from the bottom up.