PDA

View Full Version : Automatic Updating of Functions in Excel



Phatie17
06-13-2007, 07:07 AM
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
06-13-2007, 08:04 AM
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
06-13-2007, 08:13 AM
I hesitate to say this, but maybe add

Application.Volatile

to the function