Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm doing some long-overdue code cleanup, breaking down one large XLA
into a series of smaller ones. During one of these moves, one module will no longer compile because it cannot find the "Eval" function. I seem to have the same References list for both, but I guess I don't. Where is Eval located? Maury |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Eval isn't built into excel or VBA.
My bet is that it was a function in one of the modules in that large addin you're fixing. Go back to that workbook and search for it. Maury Markowitz wrote: I'm doing some long-overdue code cleanup, breaking down one large XLA into a series of smaller ones. During one of these moves, one module will no longer compile because it cannot find the "Eval" function. I seem to have the same References list for both, but I guess I don't. Where is Eval located? Maury -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try Evaluate, not Eval
"Maury Markowitz" wrote: I'm doing some long-overdue code cleanup, breaking down one large XLA into a series of smaller ones. During one of these moves, one module will no longer compile because it cannot find the "Eval" function. I seem to have the same References list for both, but I guess I don't. Where is Eval located? Maury |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Aug 27, 4:20*pm, Bob Umlas, Excel MVP
wrote: Try Evaluate, not Eval That did work. Odd, the help system didn't pull it up, and there's definitely no code in the old library that covers Eval-Evaluate. Maury |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
small "sum" function usually located @ LR screen is gone | Excel Discussion (Misc queries) | |||
Please add a "sheet" function like "row" and "column" functions | Excel Programming | |||
VB Find String located after "/" | Excel Programming |