| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Interpretation of a piece of code
Can any friend explain to me what is the following part of code means:
Application.Caller.Parent.Evaluate |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Interpretation of a piece of code
I bet that this was used in a UDF.
If I'm right... Application.caller would be the cell that held the UDF. application.caller.parent would be the worksheet that held that cell. application.caller.parent.evaluate means to use that worksheet for any unqualified ranges in the string that is being evaluated. msgbox worksheets("sheet1").evaluate("a1+b1") and msgbox worksheets("sheet2").evaluate("a1+b1") would use A1 and B1 from Sheet1 and Sheet2 (respectively) FARAZ QURESHI wrote: Can any friend explain to me what is the following part of code means: Application.Caller.Parent.Evaluate -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Interpretation of a piece of code
"Dave Peterson" wrote in message ... I bet that this was used in a UDF. If I'm right... It was. It was something I gave him. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Interpretation of a piece of code
It looked like your typing <vbg.
Bob Phillips wrote: "Dave Peterson" wrote in message ... I bet that this was used in a UDF. If I'm right... It was. It was something I gave him. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is wrong with this vba piece of code? | Excel Discussion (Misc queries) | |||
| Interpretation for: =INDEX(MATCH(1 <--one | Excel Discussion (Misc queries) | |||
| Interpretation | Excel Discussion (Misc queries) | |||
| Interpretation of T test results | Excel Worksheet Functions | |||
| chitest and interpretation of the result | Excel Worksheet Functions | |||
Hybrid Mode
