This is true, but his stats come a bit further after he says it doesn't
matter in Classic Excel.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim Rech" wrote in message
...
Despite what Ron may say...not as pronounced

His stats bear that out so I don't think he disagrees with you.




--
Jim
"Jon Peltier" wrote in message
...
| Despite what Ron may say, taking this approach (not selecting objects
before
| editing them) in Classic Excel (97-2003) also results in improved VBA
| performance. The improvement in Classic Excel is not as pronounced, but
it
| is still significant.
|
| - Jon
| -------
| Jon Peltier, Microsoft Excel MVP
| Tutorials and Custom Solutions
| Peltier Technical Services, Inc. - http://PeltierTech.com
| _______
|
|
| "Jim Rech" wrote in message
| ...
| There may be ways to improved Excel 2007 performance in specific cases
| (e.g., http://www.rondebruin.nl/shape.htm) but it seems that in
general
| Excel 2007 is half as fast as 2003.
|
| --
| Jim
| "excelfrustrated" wrote in
| message ...
| |I am about to go back to excel 2002 and dump 2007. It is much slower
| than
| | 2002. My pc meets all the requirements and I even formatted the
disc
| and
| | re-installed win xp pro. Is there a fix for this problem? thanks.
|
|
|
|