Skip to content

Instantly share code, notes, and snippets.

@DuongAQ

DuongAQ/SheetList.bas

Last active March 20, 2019 08:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DuongAQ/3ca9056f7f1ba9414df17e95ab01ce94 to your computer and use it in GitHub Desktop.
Save DuongAQ/3ca9056f7f1ba9414df17e95ab01ce94 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SheetList.bas
Sub SheetList()
Dim ws As Worksheet
Dim lr As Long
lr = 2
For Each ws In ThisWorkbook.Worksheets
Sheets("MENU").Range("A" & lr).Value = ws.Name
lr = lr + 1
Next ws
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment