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.
(E-Mail Removed)
-----------------
www.Newsgroup-Binaries.com - *Completion*Retention*Speed*
Access your favorite newsgroups from home or on the road
-----------------

»Ken Steinhoff« <(E-Mail Removed)> 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.

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
> (E-Mail Removed)
> -----------------
> www.Newsgroup-Binaries.com - *Completion*Retention*Speed*
> Access your favorite newsgroups from home or on the road
> -----------------

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 <(E-Mail Removed)>,
Ken Steinhoff <(E-Mail Removed)> 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?

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
> (E-Mail Removed)
> -----------------
> www.Newsgroup-Binaries.com - *Completion*Retention*Speed*
> Access your favorite newsgroups from home or on the road
> -----------------