My code is having trouble assigning a new name to a worksheet. I thought
this would work ws2.Name = ws1.Range("L4"). Cell "L4" on ws1 contains the
function TODAY(). I thought this would go ahead and assign todays date to
the name of ws2. The code breaks and the run time error does mention I
cannot use any / \ * etc. in the name. I tried to format the date to
something like 3-10-06 but to no avail. What the heck is wrong with this
simple request?