Thursday, May 26, 2005

Clarification

Yesterday I wrote a post about using screenupdating and displayalerts. I obviously didn't make it very clear how to do this.

Jon Peltier wrote the following:
I think you mean:

Application.ScreenUpdating = False
Application.DisplayAlerts = False

at the beginning, and

Application.ScreenUpdating = True
Application.DisplayAlerts = True

at the end of a macro.

The use of VBA arrays rather than the worksheet cells is definitely a huge time saver.

Another big timesaver is to avoid selecting an object before then doing something with the selection object.

For example, replace

ActiveChart.PlotArea.Select
Selection.Width = 250

with this

ActiveChart.PlotArea.Width = 250

BTW, both the Contextures.com site and my PeltierTech.com site now feature RSS feeds. Not a big deal, since I update mine about every two weeks.

- Jon

Thanks a lot Jon for that helpful stuff.


Posted by: Jethro | 6:40 PM |