Macro to Split Data Onto Separate Sheets

Originally Posted by kestefon

"Sheets.Add(after:=Sheets(Sheets.Count)).Name = e"

When you debug, what was the name, variable e ?
You can move the cursor over "e" and name should come up.

Notice:
You can not use the string such as:
1) Exceeds the length of 31 characters.
2) Contains invalid character(s). i.e "?", "\", "/", "[", "]", "*", ":"