balaji3081
Member
Hi All,
I need the hide rows macro to run after the selection is made from a drop down list, which will trigger the change in value in column AE, currentl;y I have to run it using Alt +F8.
Please advice.
I need the hide rows macro to run after the selection is made from a drop down list, which will trigger the change in value in column AE, currentl;y I have to run it using Alt +F8.
Please advice.
Code:
Sub HideRows()
BeginRow = 1
EndRow = 100
ChkCol = 31
For RowCnt = BeginRow To EndRow
If Cells(RowCnt, ChkCol).Value = 1 Then
Cells(RowCnt, ChkCol).EntireRow.Hidden = True
End If
Next RowCnt
End Sub