Automatic Updating of Functions in Excel

[Phatie17]

I created a function which is used in Excel and it does not always update. Is there a way to always get the function to update. When ever it doesn't update I get an error value #Value, but there is not an error with the function. When this happens I just go into the cell and refresh that cell and it works fine. Right now I have it on manual update so evern when I push F9 it does not update my user defined functions.

[lucas]

You might try setting it to automatic in the code before you run it and then set it back to manual when done...why are you using manual?
With Application
.Calculation = xlAutomatic
End With

[Bob Phillips]

I hesitate to say this, but maybe add

Application.Volatile

to the function