List All Sheet Names In An Excel Workbook With & Without VBA

In this video, we take a look at how to generate a list of sheet names in an Excel workbook with and without VBA.

VBA method code:

Sub ListAllSheets()

Dim ws As Worksheet
Dim Counter As Integer

Counter = 0

For Each ws In ActiveWorkbook.Worksheets
ActiveCell.Offset(Counter, 0).Value = ws.Name
Counter = Counter + 1
Next ws

End Sub


XML Macro 4 method formula:

=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"") 👇

Check out my full courses and ebooks here
👉 https://www.howtoexcel.org/courses/

DOWNLOAD the example workbook here
📖 https://www.howtoexcel.org/downloads/

SUBSCRIBE & get my 3 FREE eBooks
📧 https://www.howtoexcel.org/newsletter/

CONNECT with me on social
Facebook:   / howtoexcelblog  
Twitter:   / howtoexcelblog  
LinkedIn:   / john-macdougall  

Thanks for all your support!