Nope, still takes forever. all the other macros that occur on that page dont
take nearly as long. could it just be the size of the sheet? 4000 rows?


Bob Phillips wrote:
Maybe turn off automatic calculation

Application.Calculation = xlCalculationManual

at the start, and back on at the end

Application.Calculation = xlCalculationAutomatic

I guess it does stop, but it takes years to perform. i changed it to not
screen update and it still takes forever. Any ideas to speed it up?
[quoted text clipped - 9 lines]
will
have another button that will unhide all those rows. Thanks,

--
Message posted via http://www.officekb.com