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.Calculat
End Su

I appreciate your help

E