Andi,

Try the following:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A1:A10")) Is Nothing
Then
' do something
End If
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Andibevan" wrote
in message ...
Hi All,

I understand how to set up a worksheet so that a macro is
called when the
value of a specific cell changes (i.e. when Cell A1 changes),
but how do you
call a macro when a cell within a range changes (a1:a10).

I know this is simple but I can't find the right arguments?

Any ideas?

Ta

Andi