Solved: Sort Question

[gimli]

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]

Are you using

[VBA]Application.ScreenUpdating = False[/VBA]

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

[gimli]

Bah...im so stupid.

thanks..that did it.