Updating a sheet name in Excel without macros?

Posts
2
Registration date
Wednesday April 25, 2018
Last seen
April 25, 2018
- - Latest reply: ac3mark
Posts
10909
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 7, 2018
- Apr 26, 2018 at 04:59 PM
Hey everyone,

I've been working on a project and in order to do it how I was planning, I need to update sheet names dynamically without using macros. Is there any way to do this?
See more 

Your reply

1 reply

Best answer
Posts
10909
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 7, 2018
1
Thank you
Yes using VBA.

take a look here:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba

It will assist with the syntax, and give you some hints to METHODS.

Ok I was bored....

Sub makesheet()
Dim sheetname, theindex
sheetname = ThisWorkbook.Worksheets("Sheet1").Range("A1").Value
ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count)
theindex = Worksheets.Count
ThisWorkbook.Worksheets(theindex).Activate
'added this after realizing I needed to see if the sheet already existed
On Error GoTo alreadyexists

ActiveSheet.Name = sheetname
Exit Sub

alreadyexists:
sheetname = sheetname & theindex
ActiveSheet.Name = sheetname

End Sub


If you need help opening up the developer tab to get to the VBA project Explorer, let us know!

Thank you, ac3mark 1

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM has helped 2580 users this month

Graudenzo
Posts
2
Registration date
Wednesday April 25, 2018
Last seen
April 25, 2018
-
Thank you for this! Unfortunately, I was really unclear in my question. I am trying to update a sheet name based on the value of a cell within that sheet. I have managed to do this using VBA; however, I need it to work on an IPad which does not support macros. Is there any way to do this without VBA or is there a workaround for the Macro issue on the IPad? I have looked around but I have not been able to find anything so far.
ac3mark
Posts
10909
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 7, 2018
-
Not that I am aware of, but I am a PC guy! Thanks for the feedback!

Have fun!
Respond to ac3mark