Please add a "sheet" function like "row" and "column" functions

[Guest]

Please could you add a "sheet" function to Microsoft Excel: It should show
the sheet of the selected cells, like the "row" and "column" functions

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...fd61845&dg=microsoft.public.excel.programming

 

[Arvi Laanemets]

Hi

Why not to use a formula in cell, like
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31)


Arvi Laanemets

Please could you add a "sheet" function to Microsoft Excel: It should show
the sheet of the selected cells, like the "row" and "column" functions

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=91d1fb1e-e8
6c-4613-b07d-48e88fd61845&dg=microsoft.public.excel.programming

 

[Tom Ogilvy]

=cell("filename",A1)

already contains the sheet name, you just need to parse it out.

--
Regards,
Tom Ogilvy

Please could you add a "sheet" function to Microsoft Excel: It should show
the sheet of the selected cells, like the "row" and "column" functions

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...fd61845&dg=microsoft.public.excel.programming