Updating a sheet name in Excel without macros?

Graudenzo 2 Posts Wednesday April 25, 2018Registration date April 25, 2018 Last seen - Apr 25, 2018 at 08:28 AM - Latest reply: ac3mark 9309 Posts Monday June 3, 2013Registration dateModeratorStatus May 16, 2018 Last seen
- 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

3 replies

ac3mark 9309 Posts Monday June 3, 2013Registration dateModeratorStatus May 16, 2018 Last seen - Updated by ac3mark on 26/04/18 at 05:03 PM
+1
Helpful
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!

Graudenzo 2 Posts Wednesday April 25, 2018Registration date April 25, 2018 Last seen - Apr 25, 2018 at 06:56 PM
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 9309 Posts Monday June 3, 2013Registration dateModeratorStatus May 16, 2018 Last seen - Apr 26, 2018 at 04:59 PM
Not that I am aware of, but I am a PC guy! Thanks for the feedback!

Have fun!
Respond to ac3mark