To be honest with you, I don't know how to use a user defined function. I
would like to learn how, I am sure it would be helpful.

"Dave Peterson" wrote:

> You had two responses that suggested that you use a UserDefinedFunction to
> return the name from the formula at one of your other posts.
>
> Didn't either of them work?
>
> InfinityDesigns wrote:
> >
> > I am not sure what happened to my last thread. I was getting valuable
> > information from someone but my thread disappeared. What I am trying to do
> > is this, If I type =HollywoodHills in K10 it returns a value from that
> > defined name of $34.56 which is the retail price of that product. I have
> > another defined name of "HollywoodHillsC" which will return the value of
> > $20.25 which is the wholesale price of the same product. The defined names
> > will change with each product line on the form. So I want to be able to type
> > =HollywoodHills in K10 have another cell say N10 that will not be visible to
> > the user that will have the same name in it, and then use a formula or macro
> > to add the letter "C" to the end of it to return the wholesale price of
> > whatever product is in K10. This other cell will not be visible by the user
> > because some users should not have access to wholesale pricing. Can anyone
> > help???
>
> --
>
> Dave Peterson
>