Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Evaluate("5705")
Hi guys,
Could you try something for me? Open Excel, go to vbe, open immediate window and execute ? Application.Evaluate("5705") Could you tell me what value you get and why I get -4146 Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Evaluate("5705")
I think you should tell us which version and Service Pack of Excel you are
using and which operating system it is running on. I am using Excel 2003 SP 3 on Vista Ultimate and that expression prints 5705 for me. -- Rick (MVP - Excel) "witek" wrote in message ... Hi guys, Could you try something for me? Open Excel, go to vbe, open immediate window and execute ? Application.Evaluate("5705") Could you tell me what value you get and why I get -4146 Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Evaluate("5705")
I got 5705, not sure why you got what you did.
"witek" wrote: Hi guys, Could you try something for me? Open Excel, go to vbe, open immediate window and execute ? Application.Evaluate("5705") Could you tell me what value you get and why I get -4146 Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Evaluate("5705")
I just fired up my XL2007 SP2 and the expression prints out 5705 on it as
well. -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... I think you should tell us which version and Service Pack of Excel you are using and which operating system it is running on. I am using Excel 2003 SP 3 on Vista Ultimate and that expression prints 5705 for me. -- Rick (MVP - Excel) "witek" wrote in message ... Hi guys, Could you try something for me? Open Excel, go to vbe, open immediate window and execute ? Application.Evaluate("5705") Could you tell me what value you get and why I get -4146 Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Evaluate("5705")
Rick Rothstein wrote:
I think you should tell us which version and Service Pack of Excel you are using and which operating system it is running on. I am using Excel 2003 SP 3 on Vista Ultimate and that expression prints 5705 for me. Excel 2003 (11.8307.8221) SP3 Server 2008 64, Windows XP. It does not matter. It is even more weird. It gives -4146 during debugging in one instance of Excel . If I run another instance of Excel at the same time it gives right value. Any idea? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Evaluate("5705")
witek wrote:
Hi guys, Could you try something for me? Open Excel, go to vbe, open immediate window and execute ? Application.Evaluate("5705") Could you tell me what value you get and why I get -4146 Thanks More fun ? Application.Evaluate("5705") -4146 5705 -4146 5705 is when my file is closed. -4146 when my file is open |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Evaluate "nested-merge" 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) | |||
How does Excel evaluate embedded "IF" statements | Excel Programming | |||
"WinForm Application" to act as "RTD Server" using .Net | Excel Discussion (Misc queries) | |||
?Application.Evaluate("max(len(A1:X20))") | Excel Programming |