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.
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?
[VBA]With Application
.Calculation = xlAutomatic
End With[/VBA]
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
I hesitate to say this, but maybe add
Application.Volatile
to the function
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
