To save each worksheet as a separate PDF:.Sub SortSheetsTabName() Application.ScreenUpdating = False Dim ShCount As Integer, i As Integer, j As Integer ShCount = Sheets.Count For i = 1 To ShCount - 1 For j = i + 1 To ShCount If Sheets(j).Name < Sheets(i).Name Then Sheets(j).Move before:=Sheets(i) End If Next j Next i Application.ScreenUpdating = True End Sub
FREE MACROS FOR EXCEL THAT SEPARATES COLUMNS HOW TO
To use this code, follow the instructions on how to run macros outlined above.
![free macros for excel that separates columns free macros for excel that separates columns](https://excelchamps.com/wp-content/uploads/2015/12/useful-macro-codes.png)
You can find this code in your saved macros.
![free macros for excel that separates columns free macros for excel that separates columns](https://www.myexcelonline.com/wp-content/uploads/2019/01/How-to-Autofit-Rows-02.jpg)
Now your macro is saved and you can use it whenever you want.
![free macros for excel that separates columns free macros for excel that separates columns](https://howtoexcelatexcel.com/wp-content/uploads/2018/02/MACRO-MONDAYS-SAVE-FILE-WITH-TODAYS-DATE-768x722.gif)
When you finish, click Stop Recording.Click OK and perform the action you’d like to save.In the name section write a name for this macro, choose a shortcut key and the description for the process this macro does.