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

[Spreadsheet Monkey]

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/comm...el.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


"Spreadsheet Monkey" <Spreadsheet [email protected]> wrote in
message news:[email protected]...
> 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/comm...id=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

"Spreadsheet Monkey" <Spreadsheet [email protected]> wrote in
message news:[email protected]...
> 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/comm...el.programming