|If your Dates have / (slashes) they will not work because Sheet names cannot contain slashes.|
You have to use something like MONTH(A1) & "-" & DAY(A1) & "-" & YEAR(A1) to create a date like 5-17-2012.
re: "how do I accomplish the same thing without the TOC?"
Well, since the code in that thread creates a TOC, you obviously don't want the "same thing".
What do you want?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.