Hi.

I have a macro that because of its nature, takes over an
hour to complete - the code is fine, just processing lots
of data.

When I used to programme in Delphi, there was a method
called Application.ProcessMessages which allowed let the
CPU handle other tasks while churning away on the CPU
intensive code.

I was wondering if VBA has an equivalant? I can't seem to
find anything as currently I can't do anything else while
I run this macro.

Thanks for your help,
Bryan