Selection.EntireRow.Insert Inserts too many Rows!

[nickv02]

I have written a simple code to sort and separate data in my spreadsheet. The issue I am having is when it separates the data, instead of the insertrow function only inserting one row, it inserts the same number of rows as the data it is moving. i.e. If the data has 15 rows, with 10 being alike, and the other 5 alike, it will insert a row after the 10th row, but it will insert 5 blank separating rows (corresponding to the number of rows it has displaced) instead of 1. What am I doing wrong here?

Thanks!

Please Login or Register  to view this content.

[StevenM]

The problem is this:

Please Login or Register  to view this content.

You insert a row, and then on the next loop, the values don't match and so it add another row.

You might change it to:

Please Login or Register  to view this content.

[nickv02]

That solved the issue, thank you!