Maybe turn off automatic calculation

Application.Calculation = xlCalculationManual

at the start, and back on at the end

Application.Calculation = xlCalculationAutomatic

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"brownti via OfficeKB.com" <u31540@uwe wrote in message
news:6dcc61eb87ed0@uwe...
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?



brownti wrote:
This works except it doesnt stop once it has checked the sheet once. it
just
continues checking...

Sub HideGrey()

[quoted text clipped - 21 lines]
rows that have a gray background in column A of that row. And then i
will
have another button that will unhide all those rows. Thanks,

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