when to use WaintForIdle

[#1]

I use a long QV macro to do some things in an excel sheet

Sometimes my macro doens't get through.

My thought is that i should sometimes use a 'waitforidle' instruction.

But when should I use it ? After what type of actions ?

Thanks for yout time !

[arieidel]

It is strange that sometimes your macro works and sometimes it doesn't. Let the macro do the simplest actions so you won't be surprised.

Try to use Sleep method... Maybe it also could be useful to see the process step by step.

Hope it help!