It might hep to post the code that you are using.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Airfive" wrote in message
...
Hello all,

I have read some posts regarding creating named worksheets but I am unable
to get it to work properly for me. I am using the macro from Dave
Peterson.
My "List" contains the following in column A......JAN 07, FEB 07, MAR 07
etc.
formatted in a text format. I want the macro to create and name the
worksheets as listed above but it won't work. I'm sure I'm doing
something
dumb.....lol......can someone help? Thanks.

Ron