Here's what i want to do I have a category which is Hotel, Mall & Bank list is "D6" each category has some details - Hotel(A8:A41) ,Mall(A8:A25) Bank(A8:A17) so when i select mall 26:41 is blank, bank 18:41 and i want to hide those blank rows.
I used this code but it only works for Mall.
Someone please enlighten me..
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("$D$6")) Is Nothing Then
Range("18:41").EntireRow.Hidden = .Value = "Bank"
Range("26:41").EntireRow.Hidde = .Value = "Mall"
Thank you so much