Put Name's Refer's to: field in cell

[kittronald]

Garry, Rick and Clif,


The UDF is working correctly within the macro as wanted. 8)

Getting the UDF to work in a cell was a backup solution since I'm
learning to write macros on the spot.

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 ?

Thanks for the help guys !



- Ronald K.

 

[Rick Rothstein]

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)