Function firing alone randomly

[ggs22]

Hi all,
I have created a function returning a date with two arguments: two numbers that come from cells within the same workbook. When any event-type change occurs in any sheet (for instance deleting/copying range, changing the value of a range), the function fires alone with the two last given arguments. Moreover when the compiler gets the the the "End Function" line, it fires the same function over for about 5-10 times. I tried to set application.enableevents=false as a test and it worked. When I set it back to =true again, the function wasn't firing alone.. until the workbook is re-opened. Does anyone have a clue about what could be the explanation?

Thanks,

[pjwhitfield]

When you say "any event-type change occurs" what exactly do you mean?

If you're firing the function on any data changing then Im assuming your function then changes a cell itself which in turn will then trigger the function again....etc etc

[ggs22]

Thanks for replying so quickly,
Actually no, the function returns a date value used only in the VBA code. I have noticed the function fires when any of the changes mentioned above occurs and I think it is event related since disabling events prevent that. For instance, the latest event I have tested is closing the workbook, even though I have no code for that event, the function is triggered.

[ggs22]

Ok I got it, someone put the UDF in a couple of cells in the workbook. The UDF is therefore triggered by any change, look up UDF calculation sequence in google. As for the workbook_close() event, it resets the value of a particular cell, hence the function is triggered.