Hi,
How do I get sheets names automatically?
I.E.
I want to get in A2 sheet number 2 name.
In A3, sheet number 3 name...
Tnx in advanced!
Hi,
How do I get sheets names automatically?
I.E.
I want to get in A2 sheet number 2 name.
In A3, sheet number 3 name...
Tnx in advanced!
You can do this with this UDF
and use formula:
=SHEETNAME(ROWS($A$2:A2),TRUE)
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks