User created function not "updating"

[Richard Edwards]

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

 

[Frederik]

Does your function contains the line

Application.Volatile

(as first line!)...

greetz

 

[Richard Edwards]

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]

Maybe something with...

Application.Calculation=xlManual

or

Application.ScreenUpdating=False (so you will not SEE that Excel is
recalculating)
<code>
Application.ScreenUpdating=True

greetz