Hi Bernie,

Hi Bernie,

Adding:

Application.Volatile

at the head of the function, should allow all of the function cells to
recalculate when the sheet is recalculated.

---
Regards,
Norman


"bw" wrote in message
...
I have a user defined function that is working quite well. This function
refers to data in it's own workbook. But the workbook is updated when
reading in a delimited txt file.

Everything updates properly as it should, except the cells using the USD.
Pressing F9 updates these cells only sometimes, but I haven't been able to
figure out when.

The sure way to update them is to press F2 in each cell, and then press
enter.

Can someone explain why these cells are not updating automatically?

Thanks,
Bernie