Advertisement
Guest User

Untitled

a guest
Jan 16th, 2018
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.11 KB | None | 0 0
  1. Sub SheetNames()
  2. Columns(1).Insert
  3. For i = 1 To Sheets.Count
  4. Cells(i, 1) = Sheets(i).Name
  5. Next i
  6. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement