Updating a sheet name in Excel without macros?
Closed
Graudenzo
Posts
2
Registration date
Wednesday 25 April 2018
Status
Member
Last seen
25 April 2018
-
25 Apr 2018 à 08:28
Blocked Profile - 26 Apr 2018 à 16:59
Blocked Profile - 26 Apr 2018 à 16:59
Related:
- Excel list sheet names without macro
- How to copy data from one excel sheet to another - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Excel hyperlink to another sheet - Guide
- Count names in excel - Guide
- How to copy data to multiple worksheets in Excel - Guide
1 response
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....
If you need help opening up the developer tab to get to the VBA project Explorer, let us know!
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!
25 Apr 2018 à 18:56
26 Apr 2018 à 16:59
Have fun!