As ALWAYS, post your code for comments

application.volatile

as your FIRST LINE in the macro


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Falcon Feet" <Falcon wrote in message
...
I created my own Excel worksheet function in VBA. The function (formula)
works correctly when entered in a cell, but it does not recalculate when
the
cell that the formula references changes. FYI, the workbook's
"Calculation"
option IS set to Automatic.