Seems a very difficult way to price things when a simple vlookup would
provide your pricelist, but you should be able to use a formula much more
quickly than a macro. The formula would be something like =A1&"C"

If "HollywoodHills" were in A1, this would return HollywoodHillsC to the
cell in which the formula resides. You can then copy the cell(s) with this
formula, and Edit-Paste Special, Values.

But I think you should have used a vlookup to perform this function.
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"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