Nick - not too sure what you mean in your post.

My reasoning by my post is that...

instead of moving forward through the loop and then resizing it t
ensure that all cells in the usedrange are covered (they increase du
to the insertrow method).

Set the looplength to start with and process from the end to the start
thereby making redundant the need to resize with inserting of rows.

what may not be apparent from the orginal post is the inserting of row
is directly relational to the position in the loop.
i.e. .Cells(lngLoopLength + 1, 1).EntireRow.Insert shift:=xlDown

I think this makes sense

--
MattShoreso
-----------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...nfo&userid=347
View this thread: http://www.excelforum.com/showthread.php?threadid=57212