i would like to start a macro only if a particular range of cells have been recalculated
J johnT Mar 6, 2005 #1 i would like to start a macro only if a particular range of cells have been recalculated
D Don Guillett Mar 6, 2005 #2 right click sheet tab>view code>in the left window select worksheet> in the right select workshet CHANGE.>in the macro if target.address="$A$1" then call mymacro
right click sheet tab>view code>in the left window select worksheet> in the right select workshet CHANGE.>in the macro if target.address="$A$1" then call mymacro
