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
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