I did put your info in and now it gets stuck on this restarting mode, closes out my so-called template workbook which is not what i want. Why does this VBA to be so much different than SAS and why does mgmnt think if you know 1 code you know them all. If that were the case I would be making millions a year cuz I would know all coding language. And surely not working here.