List all worksheet names in 30 seconds using macro
Need to get a list of all worksheet names in Excel?
This micro lesson shows the fastest method:
A super simple VBA macro
USE THIS MACRO CODE:
---------------------
Sub ListWorksheets()
Dim i As Integer
Dim startRow As Integer
Dim startCol As Integer
startRow = ActiveCell.Row
startCol = ActiveCell.Column
For i = 1 To Sheets.Count
Cells(startRow + i - 1, startCol).Value = Sheets(i).Name
Next i
End Sub
-----------------------
Whether you're creating a table of contents or auditing a file — you’ll save time with these tricks.
✨ Learn smarter. Scroll faster. Skilli.
🔗 More at: www.skilli.me
#ExcelTips #ExcelMacro #ExcelShorts #ExcelWorksheets #Skilli #Microlearning #ExcelProductivity #VBAExcel