Macro question

[Mldeuser]

Is it possible to have a macro run by changing a cell.

I would like to have a macro run that hides certain rows depending on whether cell "Q6" has an "A" or a "C" in it

 

[lenze]

Sure: Use the WorkSheet_Change event

Private Sub WorkSheet_Change(ByVal Target as Range)
If Target.Address <> "$Q$6" Then Exit Sub
Select Case Target
    Case "A"
        'Code to Hide rows
    Case "C"
        'Code to Unhide Rows
    Case Else:
End Select
End Sub

Which rows do you want to hide?

lenze

 

[Mldeuser]

When the letter "A" is used I need to hide rows 42-45, 63-68.

When the letter "C" is used I need to hide rows 30-41, 56-60, 68-77

Thanks for the help