Thank you. I am using a text box to enter a name in a worksheet. I then want to use this same name to create a new worksheet. Actully, it is a copy of a template that I need to rename. I have other things that I need to do with this same name, but I seem to be stumped at the worksheet. I can name it from a text box, but then I can't use the name for other things without reentering it as a data string. Any suggestions would be appreciated. ...

Hi, all.
I am new to all this. Played in xl some, enjoyed it. still playing. I want to enter text into 2 adjacent cells in one worksheet, then copy a template worksheet and name it the 2-cell text (first and last names). I can do the template copy, data entry, and rename by hand, but not by code. I think maybe naming the 2-cell section, then referencing the name in renaming the worksheet, but I can't figure out how to do this. I'm sorry...