Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell display sheet name
Is it possible to have a cell auto fill with the sheet name.
I want to use the sheet name in formulas across multiple sheets. Thanks Gary |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell display sheet name
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH RP (remove nothere from the email address if mailing direct) "dingy101" wrote in message ... Is it possible to have a cell auto fill with the sheet name. I want to use the sheet name in formulas across multiple sheets. Thanks Gary |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell display sheet name
Here is a UDF that does that
Function mysheet() mysheet = Application.ActiveSheet.Name End Function Open VB Editor with ALT+F11 In the project window (generally to left) select the worksheet - look for VBAProject(YourFIleName) Use Insert|Module Copy or retype my function In Excel enter =mysheet() happy new year -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "dingy101" wrote in message ... Is it possible to have a cell auto fill with the sheet name. I want to use the sheet name in formulas across multiple sheets. Thanks Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text from one sheet cell to appear in another sheet cell | Excel Worksheet Functions | |||
Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
Sum of 3 nos. into 1 cell in another sheet relevant to specific da | Excel Discussion (Misc queries) | |||
Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |