You could have a macro set at the worksheet level on the worksheet_change event which would recalculate only the cells you are interested in like so:

[vba]
Range("A9,A10,B16").Calculate
[/vba]

This way you can query Target.Address in an if statement and have complete control over when and when not to calculate.