I have an Excel file with one worksheet containing data. I need a loop that will add 10 blank worksheets next to it. The following code makes copies of the first worksheet (the one with data). I need blank worksheets instead of copies so that I'll wind up with 1 worksheet containing data (the one that is already there) and 10 additional blank worksheets beside it. How do I modify the code to accomplish that? Thank you.
Dim wks As Worksheet, wksSource As Worksheet
Set wksSource = ActiveSheet
For varIndex = 1 To 10 Step 1
Application.DisplayAlerts = False
Application.DisplayAlerts = True