| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please add a "sheet" function like "row" and "column" functions
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please add a "sheet" function like "row" and "column" functions
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 wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please add a "sheet" function like "row" and "column" functions
=cell("filename",A1)
already contains the sheet name, you just need to parse it out. -- Regards, Tom Ogilvy "Spreadsheet Monkey" <Spreadsheet wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
