Can I Fire This Macro Auto?

[rockyw]

I have a macro that starts like this.

Sub BreakoutReDux()
Application.ScreenUpdating = False
Dim ws As Worksheet
Set ws = Sheets(2)

Is there any way I can have this fire by its self if a cell in a range updates? The code is in sheet 2, all the cells it looks at are filled by other VB code. Or can the other VB code fire this one? Thanks

 

[davesexcel]

You should be able to set it before all the subs, this then would set the varialble for all the subs in the module.

 

[rockyw]

I,m not sure what that means? Do I need to add to this or add a third cb code? Thanks

 

[rockyw]

Can I get a macro that will run this code, when a desinated cell changes? Like when Sheet2,E1 changes the macro runs this code? Thanks