How to get the list of sheet names of ms-excel?

macos microsoft-excel microsoft-excel-2011

Try using the following macro:

Sub ListWorkSheetNames()

For i = 1 To Sheets.Count
Range("A" & i) = Sheets(i).Name
Next i

End Sub

For me - works quite well.

(source)


To get the same as above but additionally with hyperlinks taking you to the sheet:

Sub ListWorkSheetNames()

For i = 1 To Sheets.Count
Range("A" & i) = "=HYPERLINK('" + Sheets(i).Name + "'!A1, """ + Sheets(i).Name + " "")"
Next i

End Sub

Related

Is there a condition for the closure of an open subset to be a manifold with boundary?
To what extent is linear stability analysis of numerical methods relevant to nonlinear ODEs?
Fitting a dodecahedron inside a cube
Smoothness of $O(n)$-equivariant maps of positive-definite matrices
Prove that there exists a prime $p$ such that $p \mid a^n-b^n$ and $p > n$
Can this integral be calculated in closed form?
What's special about 323 and squared rectangles?
How is moving the last digit of a number to the front and multiplying related to multiplicative orders?
On sufficient conditions to ensure $X/G\cong X/G'\Rightarrow G\cong G'$.
Why do all Giuga numbers have exactly one odd prime factor which is congruent to 1 (mod 4) ?
Tensor product of two quotient modules
An application of the Inclusion Principle to Chemistry? (Proof Verification)