Bob,

Not using 'select' is a personal goal of mine at the moment
I use the copy argument like yourself detailed below - can this be
used with a pastespecial without selecting anything?

J

"Bob Kilmer" wrote in message ...
Joe,
I cannot make Select violate ScreenUpdating = False. Didn't think it should.
Not sure what is causing your trouble. I'll look at your code when you post
it, unless you figure it out first. <g

As an aside, I use Select if I want the interface to show a selection, but
generally, using selecting in code is not necessary. Simply refering to the
objects creates faster, more concise code. For example the following code
was recorded:

Range("A1").Select
Selection.Copy
Range("B2").Select
ActiveSheet.Paste

This is equivalent:

Range("A1").Copy Range("B2")

--
Regards,
Bob Kilmer


"Joe 90" wrote in message
...
Bob,


I can see why Select is a problem :) but have found that if I want the
current region selected, I have to use Select ?? Will post up some code to
help with the problem.

Joe

"Bob Kilmer" wrote in message
...
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