Rename Active Sheet

J

Jason

I am using an input box to store a string which is
entered by the user as follows:

strCrossGroup = InputBox("Pool/Owner:")

I would then like the value which is entered by the user
to become the name of the ACTIVE worksheet (i.e. If I
enter "Jones" in the input box, I want the active sheet
to be renamed to "Jones"). My initial idea is something
as follows, although I am not sure how to finish it.
Thanks for your help.

Sheets(?).Select.Name = strCrossGroup
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Change event code Find .Activate does not activate Target.value 4
Masking the character in input box 1
Loop thru xx No. of sheets until the four strValue combo's are found 6
Renaming worksheets 2
Automatically save as pdf but include location 0
InputBox for column letter problem 2
Macro VBA coding, Copying content from one workbook to a new one 0

Top