Sub Macro1()
'
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Worksheets
WS.Copy
ActiveWorkbook.SaveAs ActiveSheet.Name
Next WS
'
End Sub
Sub Macro1()
'
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Worksheets
WS.Copy
ActiveWorkbook.SaveAs ActiveSheet.Name
Next WS
'
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks