hi
yes there is. bob just posted a solution.

regards
FSt1

"ranswert" wrote:

Is there a way to run the macro only when a certain cell is changed not the
whole sheet?

"FSt1" wrote:

hi
use the worksheet change event
right click the sheet tab and from the popup select view code which will
bring up the vb editor
in the left combo box above the code window, select worksheet.
put your code there. it will fire whenever data changes on the sheet.

regards
FSt1
"ranswert" wrote:

How do I start a macro whenever the contents in a cell is added or changed?
Thanks