Allie wrote:
hi

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 do


Thanks.

What's wrong with that Left() line ?

--
Regards,

Juan Pablo González