I've been struggling to try and get anything to work and hoping someone might have an idea.
If C5 has a value I Need Rows 6, 106 and 107 to become visible. I then need it to check if C6 has a value and if so make the next row visible and so on until it reaches row 106.
This will all be run under a Private Sub Worksheet_Change(ByVal Target as Range).
I hope this makes sense any help would be greatly appreciated.