And, PLEASE try to use meaningful subject lines and show a bit of patience.

--
Don Guillett
SalesAid Software

"InfinityDesigns" wrote in
message ...
The question I have is this, can you add to an existing formula in a
particular
cell. Example: I have a workbook where I fill out a work order for jobs
sold. In that workbook I have defined many names for individual products
in
several other workbooks to return a retail price and a wholesale price.
The
defined name for the retail price is the name of the product ie;
"HollywoodHills", the defined name for the wholesale price is the same but
with a "C" at the end ie; "HollywoodHillsC". I am wanting to have a macro
to
add the "C" to the end of the defined name in a cell to return the
wholesale
price of the product. This would greatly uncomplicate my life and any
help
is greatly appreciated