Problem changing a name...

It didn't work, cause it tried to name the worksheet with special characters. It used the =NOW() function and formatted it like "m/d/yy" and tried to use it as a worksheet name. And you can't include special characters such as "/" in worksheet names. Once I corrected that, it worked. All the other changes I made was just optimization. (Although I think it could be better, but I don't know what's needed at what isn't.)

Thanks again for your help.