VBA: Create sheets from list
Closed
jdamushte
Posts
1
Registration date
Friday July 20, 2018
Status
Member
Last seen
July 20, 2018
-
Updated on Jul 24, 2018 at 11:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 24, 2018 at 11:44 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 24, 2018 at 11:44 AM
Related:
- VBA: Create sheets from list
- Vba case like - Guide
- Number to words in excel formula without vba - Guide
- Vba check if value is in array - Guide
- Vba color index - Guide
- How to open vba in excel mac - Guide
2 responses
So record a macro of it and do it!
Highlight the row, cut it, select the tab, new tab, rename it "1", highlight the first row, paste the row!
It is that simple!
Have FUN!
Highlight the row, cut it, select the tab, new tab, rename it "1", highlight the first row, paste the row!
It is that simple!
Have FUN!
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 24, 2018 at 11:44 AM
Jul 24, 2018 at 11:44 AM
Since the macro recorder doesn't show you how to loop, give this code a try:
Or, when you want the order of sheets reversed:
Best regards,
Trowa
Sub RunMe()
For Each cell In Range("A1:A10")
Sheets.Add
ActiveSheet.Name = cell.Value
Next cell
End Sub
Or, when you want the order of sheets reversed:
Sub RunMe()
For Each cell In Range("A1:A10")
Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Name = cell.Value
Next cell
End Sub
Best regards,
Trowa
