Thank you for responding. I am sure that there are easier ways of doing a
lot of the things I am doing in Excel. I am fairly new to it and 100% self
taught. I did try the formula you gave me but it returned the wrong value.
When I type =HollywoodHills in cell K10 that defined name returns a value of
$34.56 that the name got from a different worksheet. Then I used your
formula in cell M10; =K10&"C". When I do this, it returns a value of 34.46C
in cell M10. Instead what I want it to return is the value that would be
returned if I had typed in M10 =HollywoodHillsC which would return a value of
$20.25. I hope I am making this clear because I could use all the help I can
get regarding this aspect.
"Anne Troy" wrote:

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