User defined function wont update

Question

I've created a user defined function in excel to automatically pull data from 2 tables and multiply them and the data it pulls is dependent on and referenced agaist the row and column titles of the cell the formula is applied to.

When I apply this to a table as a whole it will not automatically calculate or update. The only way to get it to update is to efectively refresh each cell indevidually.

Is there a way that I can make this formula dynamic and automatically update without any input? or is there a way I can write another macro to automatically update the table?

Code is below:

THis is the table after refreshing the full page:

This is after going into a cell, clicking on the function and pressing enter to recalculate:

Any help would be apreciated.

Thanks

Answer 1

Try adding a special instruction:

Function Calculate_Revenue()

   Application.Volatile True

   . . .
End Function