I'm not a VBS coder but understand inserting your code. Could you tell me
what exactly I need to modify in that code to make it work with mine?

"Don Guillett" wrote:

piece of cake. Just put it in a worksheet_change event. Right click sheet
tabview codeinsert thismodify to suitSAVE . Now when you change
something in col A a row will be inserted moving that data down one leaving
you the same row on which to type again.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 2 Or Target.Column < 1 Then Exit Sub
Rows(Target.Row).Insert

End Sub
--
Don Guillett
SalesAid Software

"AimzG8Rfan" wrote in message
...
My boss is not very computer literate and in order for him to use the
spreadsheet I created for tracking jobs, he "must" be able to insert a row
by
hitting the enter key. Basically, he wants to just type on a line, hit
enter, and be on the next line to type something -- like Word does. Any
ideas??