Excel not refreshing data for User Defined Functions

[BIT.Society.06]

Hi,

I have a problem where i created a User Defined Function, and call it
from many cells on similar sheets, ie in C1:C10 of Sheets 1,2 and 3.
The data however doesn't get updated when the cells the function looks
at are updated.
Adding Application.volatile to the start of the function fixes this,
but now when I swap between sheets the cells C1:C10 have the same
values as those from the previous sheet I was on. It is not until I
double click on the cell and press enter does the correct value
display, but changing to the first sheet (or any other sheet) repeats
this problem.

The closest I could find to this problem is here:
http://groups.google.com.au/group/m...ead/thread/34dd356cfdc8149a/b4985abb06a8da8f?

There is no mention of the sheet changing issue though, and their
solution didn't work for me.
I'm using Excel 97 SR-2

Thanks

 

[Robin Hammond]

Can you post your code. It's probably something to do with the sheet
reference.