| Home |
| Search |
| Today's Posts |
|
#15
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put Name's Refer's to: field in cell
Why is it when you create a defined name called "TEST" with a
Refers to: field equal to =SUM(A1,B1) and type =SUM(TEST,1), you don't have to wrap the name TEST in quotes ? Characters wrapped with quote marks is text... the argument to the SUM function is not a text string... if you used "TEST" as the argument, Excel's evaluator would not see the defined name TEST, rather, it would see just the individual characters T, E, S and T and would assign no meaning to them. Rick Rothstein (MVP - Excel) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modifying a Defined Name's Contents | Excel Programming | |||
| How to Print Name's list and Names Range? | Excel Worksheet Functions | |||
| How to create table of cell names with the name's cell address | Excel Discussion (Misc queries) | |||
| How do I implant a field into a cell? | Excel Discussion (Misc queries) | |||
| Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
Threaded Mode
