I am trying to create
Worksheet_Change() event to unhide rows based on the numeric value of one cell.
I have a table B13:B513. I want to unhide a number of rows equal to the value in C7. For example, if C7 = 10, then B13:B22 will unhide and the rest will still be hidden.
I have seen several ways of doing something similar but using "case" for each option. In my case I have 500 options. I am sure there is a more efficient way of doing this.
I am using Excel 2010.
Thanks in advance!