start a macro
 

i would like to start a macro only if a particular range
of cells have been recalculated

right click sheet tabview codein the left window select worksheet in the
right select workshet CHANGE.in the macro

if target.address="$A$1" then call mymacro


--
Don Guillett
SalesAid Software

"johnT" wrote in message
...
i would like to start a macro only if a particular range
of cells have been recalculated

How can i get it to run if i change a range of cells?
-----Original Message-----
right click sheet tabview codein the left window select
worksheet in the
right select workshet CHANGE.in the macro

if target.address="$A$1" then call mymacro


--
Don Guillett
SalesAid Software

"johnT" wrote in
message
...
i would like to start a macro only if a particular range
of cells have been recalculated


.