Hi Kelljeff,

Looking at your posting where you say that if EN5 has a number it does
not work, I can't see a reference to EN5 so I guess this has to be a
input for a later calculation. Check that this cell is not formatted
as text as that could give the problem.

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=529992