Works nicely, but when I right click the range and clear
contents, the spreadsheet freezes up on me.

Is there anyway to prevent this?

-----Original Message-----
Hi Lisa

You need a event

Read Chip Pearson's site about Events
http://www.cpearson.com/excel/events.htm

For example

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("D26:D29 "),
Target) Is Nothing Then
MsgBox "You changed a cell in D26:D29 "
End If
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Lisa" wrote in
message ...
I need help with a macro that will automatically run if
values in range D26:D29 have been added or changed.

Any help would be great,
Thanks


.