| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet Name in Cell
Is there a way to get the sheet name to show up in a cell? Say sheet name;
"Pear" tp show in cell B2 of said sheet? Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sheet Name in Cell
Place the following formula in B2. Note your sheet must be saved or else you
will get a #VALUE! error. =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) -- Regards, Dave "Jay" wrote: Is there a way to get the sheet name to show up in a cell? Say sheet name; "Pear" tp show in cell B2 of said sheet? Thanks, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sheet Name in Cell
Thanks, David it worked. Now, what I need is to have the workbook open to the
month sheet based on the current system month, keeping all other sheets minus the review sheet hidden. Is that possible? Looking forward to your reply. "David Billigmeier" wrote: Place the following formula in B2. Note your sheet must be saved or else you will get a #VALUE! error. =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) -- Regards, Dave "Jay" wrote: Is there a way to get the sheet name to show up in a cell? Say sheet name; "Pear" tp show in cell B2 of said sheet? Thanks, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sheet Name in Cell
You have responses at your other post.
Jay wrote: Thanks, David it worked. Now, what I need is to have the workbook open to the month sheet based on the current system month, keeping all other sheets minus the review sheet hidden. Is that possible? Looking forward to your reply. "David Billigmeier" wrote: Place the following formula in B2. Note your sheet must be saved or else you will get a #VALUE! error. =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) -- Regards, Dave "Jay" wrote: Is there a way to get the sheet name to show up in a cell? Say sheet name; "Pear" tp show in cell B2 of said sheet? Thanks, -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| if and then formula | Excel Worksheet Functions | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Linear Mode
