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.