Forum Discussion
i am trying to automatically hide or show rows depending on cell value in column O
i used this vba but it crashed my excel anyone who can thing of something i first used autofilter but then everytime i type somthing and move to a other cell excel has to load for 2 sec and it is not...
it contains a formula
Which cell(s) do the formula refer to?
It might help if you could attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar.
https://docs.google.com/spreadsheets/d/1csG7hx1BlqjZ1D_Hp93tT_iG9ChD4MuP/edit?usp=share_link&ouid=102361949175880447799&rtpof=true&sd=true its at O99 where i am testing it if you open it you may need to spam esc or excel crashes and in case you need it pasword is 123
I can avoid the crash by pressing Esc, but after that Excel keeps on running into problems. I fear it's too complicated, sorry.