Automatic Row insertion code
 

Was wondering… How would I code a procedure to always have an empty row
above the occupied cells? Example: I insert data in rows A2 to A3 and
as soon as I begin to insert data into cell A4 an empty row appears
above the occupied row (cell A5). And If I insert even more data into
the new blank row another empty row appears. This would happen with the
other occupied cells as well. I recorded a macro (“Ctrl r”) to insert
the empty row but was wondering if could be done automatically by code.
Thnx for any help. :) Sorry if this is a ran into the ground
question!!!

A B C D
1 Machine Shift Job# Notes
2
3
4
5 KBA 74
6
7
8
9 Cutter 40”
10
11
12
13 Gluer 35”


--
RJM
------------------------------------------------------------------------
RJM's Profile: http://www.excelforum.com/member.php...o&userid=24822
View this thread: http://www.excelforum.com/showthread...hreadid=383761