Thread: cell change
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
SparkyUK SparkyUK is offline
external usenet poster
 
Posts: 3
Default cell change

Works fine for me! Good luck.

"ranswert" wrote:

I have the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("drw1inforng")
If .Value < "" Then
MsgBox ("")
End If
End With
stoppit:
Application.EnableEvents = True

End Sub

'drw1inforng' is a named range on my sheet. When I make a change in this
range, nothing happens. What am I doing wrong here?
Thanks