Previous Topic Next Topic

Updating a sheet name in Excel without macros?

Closed
Graudenzo Posts 2 Registration date Wednesday April 25, 2018 Status Member Last seen April 25, 2018 - Apr 25, 2018 at 08:28 AM
 Blocked Profile - 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?
Related:

1 response

Answer 1 / 1
Blocked Profile
Updated on Apr 26, 2018 at 05:03 PM
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!

1
Graudenzo Posts 2 Registration date Wednesday April 25, 2018 Status Member Last seen April 25, 2018
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.
0
Blocked Profile
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!
0