The macro you cleaned up for me works great, what I would like it t
further accomplish is to continue to enter more lines and renumber the
in sequence based upon the amount of line the user requires.

Right now it only enters three lines and renumbers it to the next #.
need it to keep doing that further down the sheet each time the use
hits it

--
tanyhar
-----------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...fo&userid=3514
View this thread: http://www.excelforum.com/showthread.php?threadid=54950