All -

I have several macros that each input and parse a lot of data and then
format the result. Each takes a long time to run. I watch that
hour-glass for a good while, but the macros in the end do successfully
run.

I've discovered that if after several minutes I do a right-mouse-click
that that the macros immediately jump to the next step, which is a user
input.

So it occurs to me that: one, there's needless idle time going on that I
don't know how to find, and two, that if I can "program in" a
right-mouse click before the input, I'll be minutes ahead.

I apologize for not knowing how to Google this in 10 words or less. Can
anyone provide insight into what's going on?

....best, Hash

it helps if you post the code

wrote in message news:YQ1Kf.98297$4l5.60542@dukeread05...
All -

I have several macros that each input and parse a lot of data and then
format the result. Each takes a long time to run. I watch that
hour-glass for a good while, but the macros in the end do successfully
run.

I've discovered that if after several minutes I do a right-mouse-click
that that the macros immediately jump to the next step, which is a user
input.

So it occurs to me that: one, there's needless idle time going on that I
don't know how to find, and two, that if I can "program in" a
right-mouse click before the input, I'll be minutes ahead.

I apologize for not knowing how to Google this in 10 words or less. Can
anyone provide insight into what's going on?

...best, Hash

Perhaps calculation is causing the problem - the click could be interrupting
the calculation



at the top of the macro try

Application.Calculation = xlManual

and at the end

Application.Calculation = xlAutomatic

--
Regards,
Tom Ogilvy

wrote in message news:YQ1Kf.98297$4l5.60542@dukeread05...
All -

I have several macros that each input and parse a lot of data and then
format the result. Each takes a long time to run. I watch that
hour-glass for a good while, but the macros in the end do successfully
run.

I've discovered that if after several minutes I do a right-mouse-click
that that the macros immediately jump to the next step, which is a user
input.

So it occurs to me that: one, there's needless idle time going on that I
don't know how to find, and two, that if I can "program in" a
right-mouse click before the input, I'll be minutes ahead.

I apologize for not knowing how to Google this in 10 words or less. Can
anyone provide insight into what's going on?

...best, Hash