Thank you, I am redoing the Workbook. I have had a lot of trial by error's on that one. I am going to create a master and only put in the working VBA, Formulas and Macro's. Everyone has been a huge help to me and I am very appreciative of it. I am a very new to VBA and trying to under stand it all as I go.

Again thank you and I will post back once I get it cleaned up and working.