Well I deserve $50 for registering on this (&^%$$ system. May be I am having a bad day.

Your vba code probably refers to Activesheet. When you recalculate you are probably on another sheet. Pass a variable and use variable.worksheet

Cheers

Adam