Timeline for Automatically hide corresponding rows based on cell value
Current License: CC BY-SA 3.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 5, 2018 at 13:05 | comment | added | QHarr | Using .Address fixes it. I forgot to put that in. | |
| Mar 5, 2018 at 13:03 | history | edited | QHarr | CC BY-SA 3.0 | added 4 characters in body |
| Mar 4, 2018 at 21:39 | history | edited | QHarr | CC BY-SA 3.0 | added 33 characters in body |
| Mar 4, 2018 at 21:24 | history | undeleted | QHarr | ||
| Mar 4, 2018 at 21:24 | history | edited | QHarr | CC BY-SA 3.0 | added 98 characters in body |
| Mar 4, 2018 at 21:20 | history | deleted | QHarr | via Vote | |
| Mar 4, 2018 at 21:19 | history | edited | QHarr | CC BY-SA 3.0 | added 98 characters in body |
| Mar 4, 2018 at 21:02 | history | edited | QHarr | CC BY-SA 3.0 | added 16 characters in body |
| Mar 4, 2018 at 20:48 | comment | added | Storax | The Event will trigger everytime you change a cell | |
| Mar 4, 2018 at 20:32 | comment | added | Storax | Because the event is also triggered if you change a cell or several cells different than C15 and you have to make sure the event also works in this case. | |
| Mar 4, 2018 at 20:28 | history | edited | QHarr | CC BY-SA 3.0 | added 89 characters in body |
| Mar 4, 2018 at 20:22 | comment | added | Storax | Select A1:A3 and then press delete | |
| Mar 4, 2018 at 20:12 | comment | added | QHarr | I have set it to answer as shown. If there was no data that would be a different matter perhaps. | |
| Mar 4, 2018 at 19:45 | comment | added | Storax | This code will also run into an error 13. You also do not need Activesheet as the code is in the worksheet module and in this case Activesheet is clearly defined. But the idea using an autofilter is much quicker and nicer than the TO's approach to hide the rows | |
| Mar 4, 2018 at 19:38 | history | answered | QHarr | CC BY-SA 3.0 |