Can A Cell Change Run A Macro??

[rockyw]

I have a workbook where I paste a report on sheet 1, formulas on sheet 3 look for data and return it to E3:E24. This maro copies and pastes it on sheet 2 E3:E24, can I fire this macro WITHOUT me clicking anything? Can a simple cell change, any cell change in the range of sheet 3 E3:E24 make this maro run? Thnaks for any help.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("E3")) Is Nothing Then Macro
    Sheets("Sheet3").Select
    Range("E3:E24").Select
    Selection.Copy
    Sheets("Sheet2").Select
    Range("E3:E24").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub

 

[rockyw]

Here is the code that works

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("E3")) Is Nothing Then Macro
    Sheets("Sheet3").Select
    Range("E3:E24").Select
    Selection.Copy
    Sheets("Sheet2").Select
    Range("E3:E24").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub