Hi Sean,

Am Mon, 5 Aug 2013 11:34:39 -0700 (PDT) schrieb :

Instead of re-doing the whole code I tried to appendix below, but it returns <blank in Col H. Note D is <0 and E is 0

the SELECT CASE statement is into the IF-statement that checks for D is
empty and E greater than 0. So "XYZ" cannot be found there
This new case (XYZ) belongs to the IF-statement that checks D < 0 and E
is empty.
Copy the complete code and replace the old one.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2