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