PDA

View Full Version : Solved: Sort Question



gimli
04-26-2010, 07:53 AM
Hey all,

I have a sort sub that inserts columns and deletes columns when done. When this sub runs you can see the columns insert and values populate then columns delete. It happens really quick but just looks sloppy.

any way to supress that kind of stuff?

thanks much

lucas
04-26-2010, 07:59 AM
Are you using

Application.ScreenUpdating = False

at the beginning of the macro? Be sure to reset it to true at the end of the process.

gimli
04-26-2010, 08:03 AM
Bah...im so stupid.

thanks..that did it.