MACROS - how to create 10 new tabs in Excel using VBA

Published: 09 January 2023
on channel: Viet Tran

439

Below is the VBA script to create 10 new tabs in a worksheet

_____________________________

Sub CreateNewTabs()
Dim i As Integer

For i = 1 To 10
Sheets.Add after:=Sheets(Sheets.Count)
Next i
End Sub

Watch video MACROS - how to create 10 new tabs in Excel using VBA online without registration, duration hours minute second in high quality. This video was added by user Viet Tran 09 January 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 439 once and liked it 6 people.

2,804