Changing the index of a for loop inside of the loop

My code starts with a defined range from k = 2 to the total number of rows in the worksheet. The k is used to identify the row I'm at within the worksheet. TotNumOfUsedRows is found by Worksheets.UsedRange.Rows.Count. Within my loop I insert rows if certain criteria is met. Because I still need the program to go to the end of the used rows, I increase both my k and my total # of rows. I'm finding that it is exiting early, and it appears to do so when k = 1 more than the original TotNumOfUsedRows.

Sub InsertRows()
TotNumOfUsedRows = Worksheets("Name").UsedRange.Rows.Count

for k = 2 to TotNumOfUsedRows

logic here that sometimes adds a row(s), sometimes doesn't. Indexes with k to determine which row it's on

k = k + number of rows added
TotNumOfUsedRows = Worksheets("Name").UsedRange.Rows.Count

Next k

Can I change k and TotNumOfUsedRows within the for loop and have it be used as desired?

Thanks.

use a do until loop and have a variable for the (lngEndOfData) which you increase by one when you add a row?

sorry TotNumOfUsedRows not lngEndOfData

Thanks for the replies. Is the For loop not recognizing that the start and end parameters have changed? Why? For example, when I run it first, it tells me k = 2 and TotNumOfUsedRows = 17 (both correct). When I MsgBox() these values within the for loop they look correct at all times; k increases correctly and TotNumOfUsedRows does too. However, when I MsgBox(k) right before exiting the program, k = 18, which is what you'd expect if it was just going k=2 to 17. MsgBox(TotNumOfUsedRows) = 25 at end.


I believe I have accounted for the step part within it. Everything is built off of going top to bottom, and the data is chronological top to bottom, with a bunch of different nuances, so I'd rather not change it at this point!

Thank you all very much

That makes sense and it's good to know that this method won't work. I am going to play around with starting from bottom and working my way up. Thank you all.