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
Blocked Profile - Apr 26, 2018 at 04:59 PM
Related:
- Updating a sheet name in Excel without macros?
- Macros in excel download - Download - Spreadsheets
- Mark sheet in excel - Guide
- Spell number in excel without macro - Guide
- How to screenshot excel sheet - Guide
- How to open excel sheet in notepad++ - 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!
Apr 25, 2018 at 06:56 PM
Apr 26, 2018 at 04:59 PM
Have fun!