Need help speeding this loop. Hide/unhide 1200 columns based on boolean criteria

Hello fine people,

I'm trying to hide columns based on a TRUE/FALSE criteria within a range. IN another thread, I read that moving my range into an array would speed up the loop. It helped a little but this is still too slow for my liking. Any suggestions?

Please Login or Register  to view this content.

Anyway, 1200 columns with data is a lot of work for excel.

1. You could use two area variables to eliminate the "IF" statement ("IF" in combination with a reference to the columns of the sheet will slow down the code)
2. Disable others "slow downers", not just "ScreenUpdating"

and maybe it will be a little faster ...

Maybe something like that, although I do not believe it:

Please Login or Register  to view this content.