| View previous topic :: View next topic |
| Author |
Message |
pen
Power User
Joined: 15 Mar 2005
Posts: 65
|
 Posted: Tue Feb 02, 2010 6:21 am Post subject: Formula to get names of all sheets in a document. |
 |
|
I would like to get the names of all sheets in a calc document and populate a column with them. I have found Sheets and Sheet but unable to get them to work they way I would like. Am I going down the right road? Is there a way to get this information?
_________________
Paul Neale
PEN Productions Inc.
http://paulneale.com |
|
| Back to top |
|
 |
pen
Power User
Joined: 15 Mar 2005
Posts: 65
|
| Posted: Tue Feb 02, 2010 7:47 am Post subject: |
|
|
I guess I should be a bit more clear. I would like to have a function written in a cel that will retrieve the names of the sheets in the document by index.
Pseudo Code:
=SheetName(2)
_________________
Paul Neale
PEN Productions Inc.
http://paulneale.com |
|
| Back to top |
|
|
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2465
Location: Chonburi Thailand Asia
|
|
| Back to top |
|
|
pen
Power User
Joined: 15 Mar 2005
Posts: 65
|
| Posted: Tue Feb 02, 2010 9:51 am Post subject: |
|
|
Thanks, I must not have been searching for the right things as I didn't fine anything related.
_________________
Paul Neale
PEN Productions Inc.
http://paulneale.com |
|
| Back to top |
|
|
|
