Autoupdate not working

[deanelle]

Hi all,
I created a custom function for my worksheet but when copy the formula forward the cells return a #value! error and I need to click on the individual cells with the error and press enter after the formula for it to give me the correct value.

Is there a way to fix this? I'm not sure why it's doing this.

Dee

[solnajeff]

Hi

The #Value! error occurs if the cell is formatted incorrectly for the expected result, e.g a multiplication of B1 x C1 would give a #Value error if one of the source cells was text.

If you check the cell formats and calculation sources you should be able to correct the problem.

Regards

Jeff