View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
brownti via OfficeKB.com brownti via OfficeKB.com is offline
external usenet poster
 
Posts: 103
Default Hiding row base on cell content

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