Hello Joseph,

A function cannot be called upon to act upon another cell unless called from a procedure in code.

What I'm understanding is, you have this routine that adds up numbers found in comments. You want to automate this instead of having to call it when you want the new value(s)? If this is the case, you could setup a change event to run the routine when you change certain Target cells..