Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different results when running macro vs stepping into macro
My boss built a macro which returns different results when run than
when he steps through it. Before I get specific about what the macro does (since I don't have it in front of me), I thought I'd ask the general question about what might cause that to happen. If the macro works when executed manually step-by-step, I would think it should work the same way when launched. Ideas? Comments? -- Ken Steinhoff Telecommunications Manager Palm Beach Newspapers, Inc. ----------------- www.Newsgroup-Binaries.com - *Completion*Retention*Speed* Access your favorite newsgroups from home or on the road ----------------- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different results when running macro vs stepping into macro
»Ken Steinhoff« wrote:
My boss built a macro which returns different results when run than when he steps through it. Before I get specific about what the macro does (since I don't have it in front of me), I thought I'd ask the general question about what might cause that to happen. If the macro works when executed manually step-by-step, I would think it should work the same way when launched. It may access the current time multiple times: t1 = time() - value1 ' age of value1 t2 = time() - value2 ' age of value2 dt = t2 - t1 ' age difference When single stepping, dt can be LARGER than value1 - value2, although it's equal when running at once. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different results when running macro vs stepping into macro
just a thought. are you changing sheets to check results as you step through the
macro? i would make sure the ranges are fully qualified. maybe someone else will have a better idea. -- Gary "Ken Steinhoff" wrote in message ... My boss built a macro which returns different results when run than when he steps through it. Before I get specific about what the macro does (since I don't have it in front of me), I thought I'd ask the general question about what might cause that to happen. If the macro works when executed manually step-by-step, I would think it should work the same way when launched. Ideas? Comments? -- Ken Steinhoff Telecommunications Manager Palm Beach Newspapers, Inc. ----------------- www.Newsgroup-Binaries.com - *Completion*Retention*Speed* Access your favorite newsgroups from home or on the road ----------------- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different results when running macro vs stepping into macro
Just a guess, but if the macro depends on a Selection(s), it may be that
when your boss starts the step-through the Selection works, but not when run from the menu. In article , Ken Steinhoff wrote: My boss built a macro which returns different results when run than when he steps through it. Before I get specific about what the macro does (since I don't have it in front of me), I thought I'd ask the general question about what might cause that to happen. If the macro works when executed manually step-by-step, I would think it should work the same way when launched. Ideas? Comments? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different results when running macro vs stepping into macro
If there are any "external" operations which run asynchronously with the VBA
then you may get different results depending on how long those operations take. For example, automating a web page from VBA without waiting for (eg) pages to complete loading before trying to interact with them will show this type of difference. Tim. "Ken Steinhoff" wrote in message ... My boss built a macro which returns different results when run than when he steps through it. Before I get specific about what the macro does (since I don't have it in front of me), I thought I'd ask the general question about what might cause that to happen. If the macro works when executed manually step-by-step, I would think it should work the same way when launched. Ideas? Comments? -- Ken Steinhoff Telecommunications Manager Palm Beach Newspapers, Inc. ----------------- www.Newsgroup-Binaries.com - *Completion*Retention*Speed* Access your favorite newsgroups from home or on the road ----------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stepping through gives different result than running | Excel Programming | |||
Sheets("Rpt").Copy different results from running in macro than off excel menu?? | Excel Discussion (Misc queries) | |||
Macro Stepping | Excel Programming | |||
Stepping through code gives different results than running it! | Excel Programming | |||
Macros - stepping left in a macro | Excel Programming |