Formula only updating when I click on it

[madhatter40]

I have the following code that runs the "MySum" custom function. The only way it updates is for me to click in formula and hit enter. The "Calculation Options" is set to auto. I've added

Please Login or Register  to view this content.

but no luck. I can't upload due to corporate policy. Any help will be grateful

Please Login or Register  to view this content.

[BrokenDome]

Mr. madhatter40,

Good morning sir!! Just want to understand what you are asking. You are saying that you have a formula inside a cell, and you want a code that will make the formula recalculate?? Just need a little more info, thank you!!

Dome

[Fluff13]

Try adding

Please Login or Register  to view this content.

to the start of the UDF