This worked very well. Thank you very much.

ComicFly

"ComicFly" wrote:

I have a list of 40 names that I want to use to Name 40 worksheets in a
workbook. Is there a way to do this without having to type each name in each
worksheet Name area?