NumberCrunchingMonky
Technical User
In a nutshell, I have a list of projects to which I linked a graph that plots data dynamically, based on the active row of the list. I scroll up or down to a particular project title, press the button the macro is assigned to, and the graph is updated with the parameters that correspond to the project title in the active cell.
I'd like to nix the button so that the graph updates automatically when I move the active cell up and down the list. I don't know if this would be "event" driven (ie. prompted by the movement of the active cell), or better accomplished by looping the script.
Here's the code:
Sub UpdateChart()
If ActiveCell.Row > 2 And ActiveCell.Row < 20 Then _
ActiveSheet.Calculate
End Sub
I appreciate your help.
NCM
I'd like to nix the button so that the graph updates automatically when I move the active cell up and down the list. I don't know if this would be "event" driven (ie. prompted by the movement of the active cell), or better accomplished by looping the script.
Here's the code:
Sub UpdateChart()
If ActiveCell.Row > 2 And ActiveCell.Row < 20 Then _
ActiveSheet.Calculate
End Sub
I appreciate your help.
NCM
