I have created a UDF that works a treat. However, the values are not automatically calculating.
I don't use excel much and can't figure out a way to re-calculate this formula when the sheet has been updated.
I have found a manual method of ( ctrl, alt, shift + F9) but this needs to be automatic.
Can anyone help.
BTW: I have also checked the calculations tab which is set to automatic within Options.
Many thanks
Kempes
I don't use excel much and can't figure out a way to re-calculate this formula when the sheet has been updated.
I have found a manual method of ( ctrl, alt, shift + F9) but this needs to be automatic.
Can anyone help.
BTW: I have also checked the calculations tab which is set to automatic within Options.
Many thanks
Kempes