DoEvents Function
"Yields execution so that the operating system can process
other events."
Place it inside the macro that is running. Trail and
error..well...it worked for me anyway.
Look it up in VBA object browser
-----Original Message-----
Hello!
I wrote a macro, which copies data from a worksheet and
pastes it on
another, in the same workbook. It then manipulates the
data and writes
them to a file in the text format.
Logic and things run just fine, just that when the data
are being
manipulated by macro, in the worksheet, it is also
displayed (at a very
high speed) and the user doesn't necessarily have to see
them getting
manipulated and run by Excel.
So is there a way, we can blind these? I.e., is there a
way, we can
have these runs in the background, while displaying a
message 'Result
file generated!' to the user?
I would appreciate any tips.
Thanks in advance guys.
Arun.
Vtec Corp.
---
Message posted from http://www.ExcelForum.com/
.