Hi Wardides,

how do I tell the worksheet_change event that it should only run if c5
is changed ?

It will always run - you have to test the Target parameter to see if
it's the one you want - such by checking its address, or seeing if it's
inside a named range.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk