My Function is not Auto Calculating

I have created a function (shown below) and I call it from my excel sheet with the following command

=Progress_Status(Row())

Calculate is set to Automatic. The cells type is General - Not Text (I read this may be the issue, but it is not)

It calculates fine if I select the cell and press enter to re-enter the formula. But if I change any of the cells that the formuale uses it does not do anything, until I re-selct and re-press enter. I have tried doing it in various ways but no joy.

The function is as follows:-

Please Login or Register  to view this content.

Any help would be as always much appreciated

Ideally a UDF should always have any cells it requires passed to it directly as arguments. If you cannot do that for some reason then you need:

Please Login or Register  to view this content.

added to the top of your function to cause a recalculation whenever the workbook recalculates. Note that it is much better practice to pass the required cells to the function.

It should suffice to pass the whole range.