After column I has been sorted, add a numeric column immediately to the right
of your data. You can place 1 in each cell of this new column or even 0 or
any other numeric value.

Then do a subtotal on this new column based on each time column I changes.

You can then delete the new column if you want ... but you will have a blank
line between each change in column I.

Good Luck.

"KWhamill" wrote:

This sounds silly, I have a spreadsheet sorted by column I which is text, all
i need to do is insert a blank row inbetween the changes. Or If some one
could help me figure out another way to undo the remove blank row instruction
at the beginning of the code.
respectfully,
Karl