Suppressing re-draw in Excel 1

[stevexff]

I have some code that allows me to selectively hide some columns in a big spreadsheet based on criteria set n a form. It all works fine except that when it runs, I can see it working as it iterates through the columns, which looks a bit clunky.

Is there a property that I can set while it runs to suppress the redrawing until the end?

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[PHV]

Application.ScreenUpdating = False
' do your stuff here
Application.ScreenUpdating = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[stevexff]

Works perfectly, and it's massively quicker, too.

Have a star!

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]