Hello All,
I have rows 19 through 25 hidden in a worksheet called DASHBOARD. Data is pulled in from another sheet after running a macro and is displayed in the range C7:P18 as spilled arrays. I'd like to be able to have the next hidden row (19) unhide if a value is inserted in C19. After that I'd like to have row 20 unhide if a value is inserted in C20, etc. Also if there is a way to rehide a row if there is no value in C19, C20, C21, etc...that would be even better.
I'm new to VBA, so if any of you could help me out I'd really appreciate it.
I have rows 19 through 25 hidden in a worksheet called DASHBOARD. Data is pulled in from another sheet after running a macro and is displayed in the range C7:P18 as spilled arrays. I'd like to be able to have the next hidden row (19) unhide if a value is inserted in C19. After that I'd like to have row 20 unhide if a value is inserted in C20, etc. Also if there is a way to rehide a row if there is no value in C19, C20, C21, etc...that would be even better.
I'm new to VBA, so if any of you could help me out I'd really appreciate it.