Help

Joined
May 28, 2010
Messages
2
Reaction score
0
Hi,

I have a spread sheet that people insist on leving cells blank! Is there vba code to make all cells mandatory?

There was this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$2" Then Exit Sub

If Target.Value = "" Then
MsgBox "Input required!", vbInformation + vbOKOnly, "Warning"
Target.Activate
End If
End Sub

But I want it to go from cell A2 - I2?

Please help?
 
Back
Top