I thought of that, but if they don't enter things in the order I think they
should then they'll get a lot of messages. Of course, they'll learn to enter
things in the right order maybe. I'll take a look. Thanks.

Don Guillett wrote:
You could use event code that fires on an entry in the last column.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Or Target.Column < 5 Then Exit Sub
If Application.CountA(Cells(Target.Row, 1).Resize(, 5)) < 5 Then
MsgBox "finish"
End If
End Sub

I should be able to make this work, but can't. I have a worksheet that
includes a section to record checks and deposits of our school band
[quoted text clipped - 9 lines]
starting on row 11, and the deposits on row 28. Does anybody have any
suggestions? I really appreciate it.

--
Message posted via http://www.officekb.com