Blanchetdb
Board Regular
- Joined
- Jul 31, 2018
- Messages
- 153
- Office Version
- 2016
- Platform
- Windows
I found the following coding but I would like to know to adapt it to text
<colgroup><col width="64" style="width: 48pt;" span="8">
<tbody>
</tbody>
What I am looking for is where the person would select an option in Cell C36 ( example - Term) and if so, rows 95-103 would hide. There are a number of other options that would require the rows to hide as well
Private Sub Worksheet_Change(ByVal Target As Range) | |||||||
If Target = "Indeterminate" Or "Term" Or "Transfer" Or "As Required" Then Exit Sub | |||||||
If Target.Address(0, 0) <> "C36" Then Exit Sub | |||||||
Sheets("Sheet1").Rows("95:103").Hidden = Target.Value = 0 | |||||||
End Sub |
What I am looking for is where the person would select an option in Cell C36 ( example - Term) and if so, rows 95-103 would hide. There are a number of other options that would require the rows to hide as well