• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hide rows macro to run after a event

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.


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
 
Back
Top