h

If I am using wsNew.Name= c.value in a macro, how do I change that to only use a certain number of characters...

ie

wsNew.Name= Left(c.value, 5) --- Which isn't right, but that's the idea of what I want to d

Thanks.