Hi Dave,
The light is begining to go on. I appreciate your patience with me, as I am
fairly new to all of this. Thank you for sending the link to the info from
the other thread, for some reason I could no longer see it on line. I went
to Insert Procedure, clicked on Function and made it public, then pasted your
UDF in that module. I then put =INDIRECT(MID(getformula(A2),2Â*,255)&"c") and
altered it slightly. I am assuming the "A2" is the cell that I am wanting
the formula to go, I am also assuming the "2 & 255" are columns and rows that
I want to retrieve the formula from, Is that correct? If it is, I altered
those references to what I am looking for and tried it. It gave me an error
message that read "ambiguous name GetFormula". What does that mean? Thank
you again
"Dave Peterson" wrote:
You could try reading the instructions in one of the earlier posts:
http://groups.google.co.uk/group/mic...37182e45cf7c9c
or
http://tinyurl.com/7unae
InfinityDesigns wrote:
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
--
Dave Peterson