User created function not "updating"
Maybe something with...
Application.Calculation=xlManual
or
Application.ScreenUpdating=False (so you will not SEE that Excel is
recalculating)
<code
Application.ScreenUpdating=True
greetz
"Richard Edwards" schreef in bericht
...
it does now - sorry - i should have known that!
is there a way of turning this off? a little too much calculation going on
now....
"Frederik" wrote in message
...
Does your function contains the line
Application.Volatile
(as first line!)...
greetz
"Richard Edwards" schreef in bericht
...
I have a user created function that I run over data pulled in from a
external html source.
The function works properly until I refresh this external html data at
which point the function now returns #VALUE!
Once I have "updated" the cell (Press F2 and then Enter) it seems to
reinitialise and all is fine.
Can I add something to the function or perhaps the data query to fix
this?
Thanks.
Richard
|