| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q about making a function
Hi all,
I have written a function which displays a current sheet name in a cell. It is very simple and it works fine. However, I have a question. Suppose the function is called "SheetName" and the current sheet is named "Sheet1". I put "=SheetName()" in a cell and it properly display "Sheet1". However, if I change the sheet name, then the function won't automatically do the update. Any way to do the automation? Thanks a lot. Frederick Chow Hong Kong. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function Making one row out of many | Excel Discussion (Misc queries) | |||
| Would like help making a function | Excel Discussion (Misc queries) | |||
| Making name of worksheet a function | Excel Worksheet Functions | |||
| Is there anybody who can hlp in the function making!!! | Excel Worksheet Functions | |||
| Making a function somewhat volatile. | Excel Programming | |||
Threaded Mode
