Application.Screenupdating not "always" working?
If you are using Select, that may be giving you trouble. One does not need
to use the Select method to act on Excel objects. You can also hide the
sheet, the workbook, the application window in VBA while processing. I
understand that you may not want to hide the entire app.window.
Application.Screen Updating usually works as advertised. I bet there is a
way to overcome this. How about posting a little code that illustrates the
problem?
--
Bob Kilmer
"Joe 90" wrote in message
...
Hi
A part of my macro clears the contents of a part of a row, selects a range
below it, cuts the range, and then pastes it to the row previously
cleared,
and then repeats until all rows in the range are cleared. This is the only
part of the macro not "hidden" by Application.Screenupdating = false, so
the
user will see all the activity. Is there a way to overcome this?
Thanks in advance
Joe
|