Thanks for the reply but it does not work.
I updated the existing module using the VBA code above but when I try to use the two recommended formulas, it displays: #NAME?
So, what's the reason for it being displayed:#NAME?