View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dr. Schwartz[_2_] Dr. Schwartz[_2_] is offline
external usenet poster
 
Posts: 30
Default Worksheet_change event assistance

Please help me out!

I have this piece of code:

Public Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("M7")) Is Nothing Then
FillOutReport
End If
End Sub

I want to change it so that FillOutReport also is called when the M7 is
cleared - meaning any change in the cell should call FillOutReport.

Anyone able to solve this?

Thanks
The Doctor