I am parsing 26,000 + variable records by variable groups.
I am using some modified code from the following thread:
http://www.excelforum.com/excel-char...le-charts.html

Where I am having problems is with renaming a worksheet with the following code segment:

.Location Where:=xlLocationAsNewSheet, Name:=chartname

The problem seems to be with another worksheet with a similar name.

So my code has created a worksheet named LEAST BROOK LAMPREY.

When it gets to LEAST DARTER, I get an error.

I tried to manually create the worksheet and rename it and I could not rename it due to a same name error. Seems to not like the duplicate LEAST- just a guess since this is the only similarity

Is there a way around this, other than putting in underscores like LEAST_DARTER?