Code is as follows:

lngLoopLength = .UsedRange.Rows.Count

For lngIndex = 3 To lngLoopLength

"if condition met then
InsertRow
end if

lngLoopLength = .UsedRange.Rows.Count

Next lngIndex

the loop if not resizing using this method.
Ideas anyone?
tia,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=572120