Insert a blank row if number sequence is not complete.

Hello,

I am working on a large spreadsheet (100K+ rows, 8 columns) and need VBA code that would loop from row 1 to the end of the data and insert a row if the repeating number sequence of "0 through 9" in column H is missing a number. The column H example below starts with 0 in row 1 repeats all the way to the last row. My problem is that sometimes a number is missing in the sequence (like 012356789) and need to insert a blank row where the missing number would go.

0
1
2
3
4
5
6
7
8
9

Any assistance would be greatly appreciated.

Best Regards,

Sam

Maybe:

Please Login or Register  to view this content.

John,

When I tested it entered a blank cell between each row in col H only.

Try:

Please Login or Register  to view this content.