Different results when running macro vs stepping into macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken Steinhoff - 20 Sep 2007 14:34 GMT

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?

Signature

Ken Steinhoff
Telecommunications Manager
Palm Beach Newspapers, Inc.
ksteinhoff@pbpost.com
-----------------
www.Newsgroup-Binaries.com - *Completion*Retention*Speed*
Access your favorite newsgroups from home or on the road
-----------------

Reply to this Message

Marcus Schöneborn - 20 Sep 2007 14:40 GMT

> My boss built a macro which returns different results when run than
> when he steps through it.
[quoted text clipped - 5 lines]
> 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.

Reply to this Message

Gary Keramidas - 20 Sep 2007 14:42 GMT

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.

Signature

Gary

> My boss built a macro which returns different results when run than
> when he steps through it.
[quoted text clipped - 7 lines]
>
> Ideas? Comments?

Reply to this Message

JE McGimpsey - 20 Sep 2007 14:45 GMT

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.

> My boss built a macro which returns different results when run than
> when he steps through it.
[quoted text clipped - 7 lines]
>
> Ideas? Comments?

Reply to this Message

Tim Williams - 20 Sep 2007 17:49 GMT

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.

> My boss built a macro which returns different results when run than
> when he steps through it.
[quoted text clipped - 7 lines]
>
> Ideas? Comments?

Reply to this Message