View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
tina tina is offline
external usenet poster
 
Posts: 139
Default Worksheet Change

Try something like this
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("a1:a1"), Target) Is Nothing Then
macrochange
End If
End Sub
Tina
" wrote:

Dear All,

I have one cell in a worksheet and I want to fire a Macro
when this particular cell changes but not when other
cells change within the same sheet. It would be useful to
know how I can do the same for a range too. Any help is
appreciated. Thanks in advance.