Hello Tracey,

No this is not a formula ...
It is an event macro, which means it is a macro that needs to be stored
in the module of the respective worksheet ...
Go to VBE with Alt F11 and copy into module of sheet you are working
on ...
But to make it work, you will have to fix the line ' Your own
calculation ...
Hope this is clear so far ...

HTH
Carim