Row entry without keeping any row blank

[sujittalukde]

I need a solution to a problem whereby a user shall be forced to make data entry in continuous rows. ie if a user make entries at row 2, row 3 he would not be able to make entry at row 4 .

In other words, suppose a user has to make three entries . He has to use use the first three rows starting from row2 as row1 will contain header.
He shall not be able to make entries at row 4 after row 3.

Please note that the number of entries will not be fixed, it will vary for user to user.

A Wb is attached which will provide more explanation and for ready testing.

[Charlize]

?[VBA]Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Offset(-1, 0).Value = vbNullString Then
ActiveCell.Offset(-1, 0).Select
End If
End Sub[/VBA]

[sujittalukde]

Thanks Charlize,this is what was looking for. Its perfect.