| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet names code
Chip Pearson wrote: You should add a cell reference (it doesn't matter what cell) to the CELL functions. E.g., CELL("filename",A1) Without the reference, the value returned by CELL is the workbook/worksheet that is active when the cell containing the formula is calculated. If a sheet other than the sheet containing the formula is active, you'll get the wrong result. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com (email address is on the web site) "Ken Johnson" wrote in message ups.com... Thanks Chip Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Ranges | Excel Worksheet Functions | |||
| Text formatting | Excel Worksheet Functions | |||
| VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
| Macro for changing text to Proper Case | Excel Worksheet Functions | |||
| Using other workbooks.. | Excel Worksheet Functions | |||
Threaded Mode
