Worksheet_Change event issue. Fundamental problem?

[rdsmit1]

Below is my code... I recorded a macro which works fine and does what I want if I click run macro, but then I tried making it execute after a change is made to the active sheet and I get an error: "Compile error: Ambiguous name detected: Worksheet_Change"

I think that I am doing something really fundamentally wrong like (ByVal Target As Range) is not correct.... I'm not really sure what I need in the parentheses after Private Sub Worksheet_Change(???).

Thanks!



Private Sub Worksheet_Change(ByVal Target As Range)

ActiveSheet.ChartObjects("Chart 243").Activate
ActiveChart.ChartArea.Select
ActiveChart.SetSourceData Source:=Sheets("setup-smry").Range("=OFFSET('setup-smry'!$B$224,0,0,1+MAX('setup-smry'!$B$140:$AE$140),30)"), _
PlotBy:=xlRows

End Sub

 

[Richard Schollar]

Sounds to me like you have two Worksheet_Change() macros in this module - so I would check to make sure you have not duplicated them

 

[rdsmit1]

Yes that was the problem, Thanks!

But also to help better understand VBA could someone explain what is supposed to be in the parenthesis after Private Sub Worksheet_SelectionChange(???)? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Richard Schollar]

ByVal Target As Range

The above is defined by whomever wrote the code behind the Worksheet_change (I mean the Excel program team, not the end user). You should never have need to change it - just go with whatever is created when you select whichever event you want to hook into by selecting the event in the right hand dropdown of the sheet module.