Hi
the code below does not work because when starts deleting sheets, the physical locations for other sheets would be changed so the loop wont work anymore. I know I need to modify the code a bit to make it work but could not figure that out. I thought of changing the For statement to this
But still did not work for me. Thank you![]()
For x Sheets.Count to 2
![]()
Sub deletemy() Dim x As Integer For x = 2 To Sheets.Count Worksheets(x).Delete Next x End Sub
Bookmarks