Hi
I dont know if anyone can help me, but I am having problems
renaming the worksheet tabs on a spreadsheet.

I have set up a procedure that when run, opens a dialog box
and asks the user to input a name into a text box.
This name is then copied and pasted to a cell on a worksheet.

I then take a copy of an existing worksheet, and the
intention is to get Excel to automatically rename the new
copy with the name entered in the text box and pasted to
the sheet (if you see what I mean).

I am using the following code to try this last part:

Sheets("WORKSHEET").Select
Range("A1").Select ----- cell holding the name
Selection.Copy
Sheets("NEWWORKSHEET").Select ----new copy of the sheet
Sheets("NEWWORKSHEET").Name = ???????

It is the ????? I cannot seem to do. If I record a macro
of me copying the name and pasting it, the code comes out
with the actual text, not a generic "whatever is on the
clipboard".

Is there a simple way of adding this to the code, so that
whatever is entered in cell A1 can be used to rename the
worksheet??

Thanks in advance for your help

Dave